Export Label to .rpt disk file taking too long

[ScouterRoger]

CrystalObject.Export is taking an unually long time to complete. Sometimes 2 hours.

I am using Crystal Reports embedded within VB .Net (the first version). Using the report designer, I created a label, and set it up to be 2 columns, 4 rows. I am using a print-to-file printer that was set up on as a local printer, using the HP 4100 PCL5e driver.

There is a header and footer on each page, and the label was designed with two subreports for the actual label lines being printed, each being a different font and size.

My problem is that when I get to the export section of my code it can take upwards of 20 minutes to export a medium size run (100 - 200 labels). In my testing, when I remove one or the other of the subreports, the time gets knocked down to around 9 minutes (still too long, but a vast improvement).

Are there any ideas as to how I can get my exporting down to a viable time?

 

[synapsevampire]

Well you pretty much described the solution, don't use subreports.

Try constructing Views or Stored Procedures to assist with getting the data and avoiding subreports.

If you have a subreport in the details, it will fire off (launch a new SQL statement) for every row in the main report, hence the slow response.

You might also create a rowset in your app and then pass it to the report, here's the sample apps:

http://support.businessobjects.com/fix/samplescr.asp#02

-k