Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Report retrieving all records using DOA

edited May 2003 in End User
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

Comments

  • edited May 2003
    I forgot to add that I am using RB 6.03 and Delphi 5.


  • edited May 2003
    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


This discussion has been closed.