Link to home
Create AccountLog in
Avatar of John-S Pretorius
John-S PretoriusFlag for United States of America

asked on

2 Subreports sharing the same link to the main report

Previous topic answered : http://rdsrc.us/lCZiFR, and I want to ask if I have 2 subreports and want to share the same link - is this possible. Currently with on linking of the subreport 1 to a field in the main report gives the right value but when I add a second subreport and also share the same link to the same value in the main report my value changes.

Can this be done.
Avatar of John-S Pretorius
John-S Pretorius
Flag of United States of America image

ASKER

I actually found by adding another Group Header and placing the second subreport in there and linking to another copy of the same field works without changing the data. Now that I have 2 subreport which I'm 'hiding'. This approach doesn't give me much 'cleanliness' with the spaces between Groups or even when I export to Excel - any suggestions how to make a report with subreport carrying over values look a little cleaner ?

User generated image
Avatar of Mike McCracken
Mike McCracken

Are the subreports blank when they display?
If so you can format them to suppress when blank.  You can also suppress the section when blank

mlmcc
The subreports - not blank -  are being 'tweaked' text shrunk to smallest height then I change the color to white.

Suggestions with 'exporting' to excel ?
SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
If I hide the Subreport the values in the main report disappear - Previous question : http://rdsrc.us/lCZiFR - The subreport carry's values over into the main report header, I then have formulas which use these values from the subreport.

Am I doing something wrong maybe ?
Below is 'work in progress', I would like to know if I'm maybe doing something wrong here - appreciated.

GALT-Folio-Raw-Local-Complete052.rpt
ASKER CERTIFIED SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Thank you guys, James your explanation describes mlmcc's suggestion perfectly.
FWIW, I'd have probably given some points, if not most of them, to mlmcc's first post.  That had the basics.

 James