Report retrieving all records using DOA

rbuser

I have an end-user reporting application that gets info from Oracle using
DOA. The problem is that it appears to retrieve all the records for the
whole report before displaying the first page. I know that DOA has a
TOracleDataSet component with a property called QueryAllRecords that
determines whether it retrieves everything or just the first page of
records. However, my report designer component only uses a TOracleSession
component and there is no such property. How can I control the retrieval of
records so that the first page of the report comes up as quickly as
possible?

Michael Gregg

rbuser

I forgot to add that I am using RB 6.03 and Delphi 5.

digitalmetaphors

RB creates DOA components behind the scenes. Check daDOA.pas to see the
classes we inherit from DOA. You can always typecast your way back to the
DOA dataset from the report:

TOracleDataSet(TppDBPipeline(Report.Datapipeline).Datasource.Dataset)


Cheers,

Jim Bennett
Digital Metaphors