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!

Register Log in
  • Congratulations strongm 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

tlbrown88

Technical User
Jun 28, 2010
23
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??
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
lbass said:
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
Click to expand...
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.
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
lbass said:
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
Click to expand...
Yep - I figured it out late Friday night doing exactly as you suggested above. Worked like a charm. The report it still a pig with 4 subreports doing a ton of calcs off of the shared variables but I pushed it through BO-BI and that helped some, only taking 45 min now. LOL. I need this report to kick off after each EDI run through out the day so I'll work on ways to improve timing. Thanks for the reply!
 
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

B
  • Locked
  • Question
Difference of a field between 2 variable dates
Replies
1
Views
288
hilfy
hilfy
jchewsmith
  • Locked
  • Question
Report filter to run report yeartodate through yesterday
Replies
0
Views
352
jchewsmith
jchewsmith
socalvelo
  • Locked
  • Question
Limiting the number of records in groups and sub-reports 1
Replies
2
Views
247
socalvelo
socalvelo
sjill
  • Locked
  • Question
Crystal Reports - Sub Report behaving as a hyperlink
Replies
4
Views
448
kray4660
kray4660
john432
  • Locked
  • Question
Crystal Report
Replies
2
Views
450
john432
john432

Part and Inventory Search

Sponsor

Back
Top