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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal 11 Report Summary with formulas

Status
Not open for further replies.

RPOC

IS-IT--Management
Jun 17, 2003
44
US
I am using crystal version 11. with shared variables.
I created a detailed report that is working fine. I would like to create a summary report from the same report by hiding or suppressing the detail lines. When i do this my variables do not seem to be passing to the main report. Is there any way of doing this. If i suppress the other sections the summary works but that section grp 2 is not all on 1 page and has spacing all over the place.

the general layout of my report is as follows:
As stated before I am able to get the summary to work as long as grp4a is not hidden or suppressed. The problem is that section is not formatting to 1 page it spaces the page based off the subreport grp4a
Main report
gp1 -
gp2 - I am resetting shared variables in this section to zero.
gp3 - grouping value based off values in subreport.
gp4a
gp4b - this is a group for inventory id
details - contains my inventory id - this is not showing on the report
grp4a - subreport - this is linked to the inventory id i have this item not showing on the report. The sections of the subreport are in Hide. I populate values here and pass them to the main report for totals and grouping of grp3.
grp4b - this shows the information from the main report and subreport that I need.
grp3 - This is a summary of my calculations for the grouping value. these totals are based of the values in my subreport. They show values in grp4b and detail lines combined.
grp2 total for the grp3 summaries. These are based off the formula values in the subreport



 
A subreport does not run when its section is suppressed.

What you can do is make the subreport very small. Or redesign the report to avoid them, if possible.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top