Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How does one get the results of a Calculation (SharedVar) on the same line as the Sub Report?

tlbrown88

Technical User
Jun 28, 2010
22
US
Hi all - I have written tons of Crystals in the past 20+ years that contain the passing of shared variables from multiple sub reports to the main report and typically when using the shared variable data in a calculation, it always comes out best when placed on the GF below where the sub report is at in the GH.
Report comes out great, gives expected results but someone is hung up on the calculation result being a line below the "main data" (in the GH).
I've tried to explain how that comes about in the evaluation timing but they will not accept it. They want the calculation on the same line.
Is there a way to do that and I just have not know all these years??
 
You should be able to go into the section expert and select the section containing the subreport, and then format that a section to "overlay following section" or something like that. I don't have Crystal open.

-LB
 
You should be able to go into the section expert and select the section containing the subreport, and then format that a section to "overlay following section" or something like that. I don't have Crystal open.

-LB
Yeah, I managed to put the Shar Var results on the GH-a line, moved all the "details" down to GH-b and suppressed the Sub report in the GH-a line but now the thing has been refreshing for over 2 hours for 1,738 records.... so something is getting really hung up. Uggh.
 
You cannot suppress the subreport itself or the section it is in. If the subreport is in GHa with the other data you want to present, you should format the report to be invisible by suppressing all individual sections WITHIN the subreport and then removing the borders. Then select the subreport in design mode->right click->format subreport->subreport tab->check "suppress blank subreport." Next in the main report->section expert->check "suppress blank section" and also check "Underlay following sections." Then reference the shared variable from the subreport with a formula like:

whileprinting records;
shared variable x;

Place it in the GH-b section. The shared variable result should now align with the other data in the GH_a section.

-LB
 

Part and Inventory Search

Sponsor

Back
Top