Suppressing Grand Totals in Drill Downs

[pajr777]

Hi,

How can Grand Totals, contained in the Report Footer Section, be suppressed whilst drilling down?

Thanks,

Paul

 

[Nuffsaid]

Hi,

I'm assuming that your using the standard "hide drilldown ok" and "show all headers on drilldown" options.

I've found this is not allways the best option.

I use these 2 formulas and with a little modification there's no limit to how far you can drilldown.

//Place in Group Header1 and suppress

WhilePrintingRecords;
If not inrepeatedgroupheader then BooleanVar GH1Flag := True

//Keep GH2 from repeating. Conditionally format GH2 to suppress

WhilePrintingRecords;
BooleanVar GH1Flag

Using this technique you won't have to worry about report totals when you drilldown.

Just another approach...

Nuffsaid

 

[pajr777]

This doesn't work when the Grand Total is in the Report Footer section. Should I create a new group and put it in Group Footer section?

 

[Nuffsaid]

Hi Paul,

I'm a little baffeled. Can you give me a little more detail as to what is happening? How many group levels are you drilling into? Using the technique above the report total should not appear at all on the drilldown page.

Nuffsaid.

 

[pajr777]

Thanks, I got it working in the end. I used something similar, a formula in the RH section and then 'mock' page headers in the GH section.

I'm new to Crystal, and still on the learning curve!

 

[akohli]

Hi Paul,

Have been building drill-downs and found performance issues(query returns dataset in 12 seconds or less - the report takes over a minute to render - C#, CR.Net, Crystal Web Viewer) that are mitigated when I create the report as a sub-report with the same dataset.
Have you been experiencing any performance issues with your drill-downs?

Regards,

Amit Kohli

 

[pajr777]

Hi Amit,

I ran a few tests on my dataset:

Query Analyser first run: 14 secs
Web viewer: 9 secs
Query Analyser second run: 8 secs

So no, no performance issues there. I'm using CE 8.0 and the ActiveX viewer.

Paul