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

Michael Katz
Michael Katz used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
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

Author

Commented:
The subreports in RFa and RFb only shows the last variable...the first one doesnt show
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
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

Author

Commented:
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
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
So it is working in the main report but you need it to show in the subreport in the footer for each row.

Take a look at the modified report.


I changed it to create an array for prices and codes which is then used in the second subreport to get the correct price
BodyPDoc-Rev2.rpt

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial