CR XI Performance

[rci]

I'm using Crystal Reports XI with a BOE Business View and I'm trying to optimize the performance on a report. I use a SQL command in the Business View which runs in less than two minutes and returns 215K rows. Then the report takes an hour to process those rows. CR spends a lot of time on what it calls 'Compressing Summaries'. This report has 8 group levels with SUMs on 7 database columns. I'm guessing that those SUMs are what it is 'compressing'.

Does anyone know what the message 'Compressing summaries' means in the CR developer?

Thanks,
Keith

 

[Turkbear]

Hi,
Your guess is probably right, the summing is happening at the CR end, so it will be rather slow - can you create a Stored Procedure ( instead of a Business View) in the database that handles the summing before it returns any records?.Or revise the BV to do that?







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[rci]

Yes, the SQL Command does the lowest level of summarization, but the group levels are dynamically chosen by the user at run time so that's all I can pre-sum.

The owners of the database are extremely reluctant to allow any use of stored procedures. It's an ongoing battle.

Thanks for your help!
Keith

 

[lbass]

Are you using running totals instead of inserted summaries? Inserted summaries will be faster than running totals--if it is feasible to use them.

-LB

 

[rci]

I'm using the inserted summaries, not running totals.