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

Retrieving different records at the start of a report

edited April 2012 in RAP
I am running a report that processes records in one table, but there is
another table for which I need two fields from two different records.

The report prompts for starting and ending date ranges for processing
the report on the main table, and I need to fetch the record in the
other table based on the date entered for the first parameter, set a
calc variable based upon one field there, and then fecth the record for
the ending date and set another calc variable based upon one field
there.

Can this be done in RAP? What is the approach to do this and syntax, if
it is possible?

--

Comments

  • edited April 2012
    Hi David,

    If you are accessing your data in Dade, you can access your dataset(s)
    as you normally would. []; You would just
    need to create a new dataview that provides access to the separate table.

    If you are accessing data externally, you would need to create a
    passthru function to access that dataset in Delphi. See the RAP demos
    for help with this.

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.