Performance w/ Parameter-Based Grouping

[bobhagan]

I have a report where I need to select for and display running totals on a group level for Worker, Supervisor, Boro, and City. I thought that changing the group with a parameter was the ideal solution (otherwise I need to maintain multiple versions of the report). However the run goes from 2/3 minutes for a field-based group to 20/30 minutes for the selectable version.

Peck says "You may pay a slight performance penalty .... Since the sorting or grouping will be done with a formula ... the ORDER BY clause won't use this formula, requiring Crystal to actually sort the data once it arrives ...."

Is there any other approach that avoids the "slight" performance problem?

Thanks
Bob Hagan

 

[MJRBIM]

You can try creating groups and sub-totals on each possible level -

EG : Group #1 - City
Group #2 - Boro
Group #3 - Supervisor
Group #4 - Worker

Then supress the groups depending on the selected parameter (ie. PARAMETER = "City" then supress the display of Header and Footer for Group #2, #3 & #4.

Let me know if that improves performance...

 

[bobhagan]

Ah!

I have a large number of running total formulas. I thought I would have to do a copy of each for every group level on the detail line to get the proper values on the summary level.

I didn't consider putting all the groups in and suppressing the ones I don't want. The parameterized group was bringing across tons of records. This has got to improve performance.

Thanks
Bob Hagan

 

[MJRBIM]

Let me know what the Performance time drops to....

Thanks.

 

[bobhagan]

See thread782-662908

Bob Hagan