3 Reports Need Help with Automation

[fmrock]

hey Everyone.

Basicly what I have to do every 6th of the month is take 3 seperate reports, run each one and export to an excel file.
Then I manually put each report on a tab in excel and create a summary tab that has the totals(record count) for the 3 reports.


I dont so much care that they are on 3 tabs, but I would like to create one report that has these 3 sub reports and then just display the 3 reports below. I dont think the people gettign these reports are even looking at the data, besides the summary.

Any ideas on how to do this?
Can i Pull the record counts from each of the sub reports?

After I get the report to pull the way i would like, then I can schedule this on the Crystal Enterprise server we have here.

BTW.. i am using CR9.

 

[Madawc]

Do a 'frame' report and import the three reports as subreports.

If you think the details are not wanted, add an option to suppress details. Or ask them what they actually do want.

For summing the values, use Shared Variables to return values to the main report and sum them there. For a currency value:

whileprintingrecords;
shared currencyvar SumSaved;
SumSaved:={#TotSaved};
SumSaved

And to access it in the main report, create another formula field with

whileprintingrecords;
shared currencyvar SumSaved;
SumSaved

Note that the shared variable is only available in the section after the section which contains the subreport.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[fmrock]

Thanks Madawc,

I know how to do the shared vars, but wanted to use them above the subreports i guess. Umm.. guess i could put a copy of them in the report header.

I can create a query to pull the summary info and then just use the subreports to display the information.

this project gives me a head ache!