cancel
Showing results for 
Search instead for 
Did you mean: 

Subreport data use to group Values in Main Report

Former Member
0 Kudos

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 ?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

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