Skip to Content
author's profile photo Former Member
Former Member

Subreport data use to group Values in Main Report

Hello,

I create a Subreport in my header to calculate values, the formula is based on a specific sorting and comparison of previous values.

In my main report I need to Group my values depending on the result. Because the group I will made on the Main Report can't be the same sorting of the SubReport.

SUB-REPORT

1 Paris (result "Capital")

2 Lille (result "Same Country of Paris")

3 Lyon (result "Same Country of Paris")

4 London (result "Capital")

5 Manchester ("Same Country of London")

MAIN-REPORT

Group

- CAPITAL (Paris, London)

- Same Country of London (Manchester)

- Same Country of Paris (Lille, Lyon)

My issue, is that I don't know how to group values on MainReport based on a formula Result of the SubReport

OR, may be there is a way to search on value in the sub-report ?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 15, 2009 at 12:50 AM

    You can't use a shared variable to group on from a sub report in the main report since a shared variable evaluation time is done whileprintingrecords.

    Try using a SQL expression to return the same result as the subreport would. You can then group on the SQL expression

    Edited by: Zilla Eh on Jan 15, 2009 6:39 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2009 at 10:25 AM

    Morning Alex,

    this one is a wild shot, are you using a shared var between the sub and main report?

    Try using a sharedvar formula and see if you can use that shared var as a group under main report.

    Regards

    Jehanzeb

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.