quick report problem

[kyriakos70]

Hello,
I have a multitier application in Delphi with database sql server express and connection socket connection, I use ado connection dataset and queries, my problem is when I run a query (to search through records) in a master detail table when I try to preview with the quick report the filtered records it returns me the right records but not the right number of pages eg. if there are 3 records in the detail and the query returns 1 the preview shows the 1 record but 3 times (3 pages), I tried to refresh the dataset on preview but nothing.

Thank you
Kyriakos

 

[DelphiAaron]

how have you created your report, using a databand or just a few fields on the page?

Aaron

 

[roo0047]

I've had that problem on some reports, others work just fine. I've never figured out why. Here's the solution I've used to solve it:

  NdeTable.SetRange([Report], [Report]);
  NdeTable.ApplyRange;
  NdeReport.QuickRep.Print;
  NdeTable.CancelRange;

Roo
Delphi Rules!