Hi All -
I'm trying to write logic that sums a total from one subreport with a dynamic total from another subreport, and then format the details of the main page to go to a new page when the sum of the totals = 29. The issue is that I can see the dynamic count happening at the second subreport level, but don't know how to use the dynamic total at the main report.
The layout of the whole mess is like this:
Page Header
Group Header 1 (where the first subreport is)
Details (where the second subreport is)
etc...
In the first subreport, I generate a sum total of all rows generated and pass the value with the following:
Whileprintingrecords;
Shared Numbervar stock_count:=(Count ({column}));
In the second subreport, I create a variable to store a count and default it to 0 in the page header of the subreport, and add one to the count with each line printed in the details of the subreport. The formulas for both are:
Whileprintingrecords;
Shared Numbervar fund_count := 0;
Whileprintingrecords;
Shared Numbervar fund_count;
fund_count := fund_count + 1;
What I'm trying to do is create the logic where (in the main report) after the first subreport fires and during the process of the second subreport, a new page is started when:
stock_count + fund_count := 29
The thing is, I don't know how to create the logic to interact dynamically with the second subreport from the main report as it is being printed. In other words, I can grab a total without issue after the subreport finishes printing, but by that time, it's too late.
If I can provide any other points that may help to describe the issue and assopciated components, please let me know. I'd sure appreciate any help that can be offered.
Thanks,
Tim
I'm trying to write logic that sums a total from one subreport with a dynamic total from another subreport, and then format the details of the main page to go to a new page when the sum of the totals = 29. The issue is that I can see the dynamic count happening at the second subreport level, but don't know how to use the dynamic total at the main report.
The layout of the whole mess is like this:
Page Header
Group Header 1 (where the first subreport is)
Details (where the second subreport is)
etc...
In the first subreport, I generate a sum total of all rows generated and pass the value with the following:
Whileprintingrecords;
Shared Numbervar stock_count:=(Count ({column}));
In the second subreport, I create a variable to store a count and default it to 0 in the page header of the subreport, and add one to the count with each line printed in the details of the subreport. The formulas for both are:
Whileprintingrecords;
Shared Numbervar fund_count := 0;
Whileprintingrecords;
Shared Numbervar fund_count;
fund_count := fund_count + 1;
What I'm trying to do is create the logic where (in the main report) after the first subreport fires and during the process of the second subreport, a new page is started when:
stock_count + fund_count := 29
The thing is, I don't know how to create the logic to interact dynamically with the second subreport from the main report as it is being printed. In other words, I can grab a total without issue after the subreport finishes printing, but by that time, it's too late.
If I can provide any other points that may help to describe the issue and assopciated components, please let me know. I'd sure appreciate any help that can be offered.
Thanks,
Tim