Link to home
Start Free TrialLog in
Avatar of Michael Katz
Michael KatzFlag for United States of America

asked on

Main Report has 3 sub reports...1 in the body of the GH3a...with the Variable showing in Ghb and then attempting to show the Ghb Values in the 2 subreports in the Main Report Footer a and b

I have a main report....

Within this  Report.. I have 1 sub report in the GHa of a main report.. and then 2 Report Footers a and b..
In each of these Report Footers I have 2 subreports... My issue is that in I cant get the variable to show per line in the 2 subreports in a and b.. like it shows in the Main report in GHA...

Any help would be great
BodyPDoc.rpt
BodyPDoc.pdf
Avatar of Mike McCracken
Mike McCracken

YOu need a formula in the report header that declares the variables otherwise it is only known in the group it is in.

If you suppress a section nothing in it will run including the subreports.
SO long as the subreport doesn't display anything, you can format it to SUPPRESS BLANK SUBREPORT
You can then SUPPRESSA BLANK SECTION

Try the report as I modified it.

mlmcc
BodyPDoc.rpt
Avatar of Michael Katz

ASKER

The subreports in RFa and RFb only shows the last variable...the first one doesnt show
The variable only has 1 value so the report footer only has the last values.

Are you trying to show a summary of all the values returned from the subreport?

Can you include the new report so I can see the new issue?

mlmcc
As you can see in the first page the 2 values show 21 and 33.. on the 2nd page the 33 shows on both lines
BodyPDoc.pdf
BodyPDoc.rpt
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial