Neverending Showing of the report in CRPE

[davidchardonnet]

Hello,

I am using Delphi 7 to display a CR XI Report.
I use the Delphi objects TCrpe and TCrpeDS to dynamically change the request of the report. It works on some reports I made but with my last one, when the Report Shows, the loading seems neverending (more than 400 000 lines). It only stops when the computer has no more memory.
I checked that the request was not the problem, and it only returns 117 rows.

Does someone knows what happens?

Thank you

David

 

[davidchardonnet]

It's not the loading of the report that is neverending, it's the data fetching.

 

[synapsevampire]

It sounds like Crystal is returning much more than you think.

400,000 lines is a lot, if by that you mean to say 400,000 rows. Lines isn't a very good way of describing technical information, unless you have some sort of line generation in the report, which seems unlikely.

Within the report, check the Database->Show SQL Query to learn what is being passed. I would guess that if you execute that you'll discover that it's returning 400K rows, and that it's missing some filtering in the where clause.

-k

 

[davidchardonnet]

Database->Show SQL
gave me the SQL request which gives exactly 117 rows, just like in the CR designer software(in which the problem does not exist).

The problem occurs only when I use it in my Delphi software.

Now I think it's because I use 3 linked data tables as a data source in the report. I am trying to use only 1 table for the report and no subreports to reduce the Report complexity.

Thanks