Sub Report Performance

[Crystalyzer]

I am running CR 9 with a CSV file as my database.

I have a main report that has 11 sub reports in it. One sub report is in the report header and is used to find duplicate first names in an employee phone listing. (Thanks to Ro and LB for helping me through that one!). The other 10 sub reports are in the Main Report Footer and are the actual listings (they are 1 inch wide "cheat sheets" with first name (and Last initial if first name is duplicated) and extension. I made the sub reports so that I wouldn't have to recreate the wheel across the page to print 10 copies of this listing on one page. I have Parameters in the main report for Office, Sortby, and Copies. The Office and Sortby parameters are linked to each of the sub reports and the Copies paramter conditionally surpress a sub report base on the number selected. (There are 10 subs the range for the parameter is 1 to 10 and each sub report is conditionally surpres by formuls: {?Copies} < 10...etc.)

All goes according to plan except that when I initially open the report and refresh it takes about 4 minutes for the report to appear. After the initial opening I can change parameters and refresh pretty quickly (not great but not too bad 5 seconds or so)

Is this normal with sub reports or is there a better design that I should have used?

Thanks and best regards,
-Lloyd

 

[synapsevampire]

Subreports are slow, however the differences you mention are suspicious.

I would think that if you were to insert 10 sections and duplicate the fields (copy and paste), you'll see a significant performance increase.

A CSV file is slow, and I'd guess that is a large part of your performance degradation. Were you to import the CSV into an Access database, apply the appropriate indexes, you'll see a significant performance leap.

-k