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.

John-S Pretorius

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 ?

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

John-S Pretorius

ASKER

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

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

John-S Pretorius

ASKER

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 ?

John-S Pretorius

ASKER

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

James0628

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

John-S Pretorius

ASKER

Thank you guys, James your explanation describes mlmcc's suggestion perfectly.

James0628

FWIW, I'd have probably given some points, if not most of them, to mlmcc's first post. That had the basics.

James