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

Accessing AutoSearch variables

edited September 2006 in DADE
Can anyone tell me how to access the values the user enters into the
"search" screen the DADE user sees when they run a report.

As an simple example I have a file with items that have a date_reveived and
a date_shipped_out. The report asks the user to enter an inventory date and
compares the inventory_date (entered in the startup query screen) and
compares the two dates against that to determine what's in stock at the
inventory_date. I would be good just to include the inventory date in the
report header so you have a printed record of what's in stock at what date.
I know what I want to do but can't find the right sysntax to set up a RAP
variable to print.

Comments

  • edited September 2006
    Hi David,

    This can be done in RAP using the TppReport.AutoSearchCriteriaByName
    routine. If for instance you have a variable inside your header band you
    could place the following code inside the HeaderBand.BeforePrint event to
    get the effect you are after...

    Variable1.Value :=
    Report.AutoSearchCriteriaByName('Customer','CustNo').Value;

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

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