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
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