Query quick but report slow

joba

Is there somebody that could assist me to make my reports faster? I use Firebird and Delphi 6 and Fast Reports 4.

I create a query (from four tables) in Delphi that run within a few seconds creating about 1060 records. I want to print the records and group them on one of the fields.

When I select the report in the program, it takes very long (I left it for more than 20-30 minutes) to create the list and still do generate the report. I tested the SQL of the query and when I create it directly on the database it creates the query in a few seconds. I selected the query as the datasource for the report.

Is there a "trick" to make the generating of the report from a query faster?

Please help!

Anu de Deus

I suppose you did set the query.Active := true before you run the report, and kept it active all the way when previewing it, right?

joba

Anu de Deus wrote: »

I suppose you did set the query.Active := true before you run the report, and kept it active all the way when previewing it, right?

Yes, I did!

gpi

Attach small demo project with problem here