Performance issue in Crystal Reports.NET

[sheridan101]

I am designing a report which querys from one SQL Server database table primarily, but pulls a couple of fields (i.e. company name, address, ...) from a different table for report page heading data.

The problem is, if I query using the main data table, performance is fine. However, the moment I add any single field from the other table to the heading area of the report, the performance more than quadruples (going from around 30 seconds to print report to over 5 minutes!!).

The two tables have absolutely no relationship at all. There are no fields linked between them. And, the "header" table only contains one record... company information. It is almost as if it is trying to requery the "header" table every time a detail record is processed from the main data table.

I am using Crystal Reports.NET.

 

[synapsevampire]

Place the header data into a subreport.

There's a slight performance hit, but not as significant.

You're getting a cross join, which will be slow (if not inaccurate).

-k