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

End User Search Criteria

edited October 2002 in End User
Hi, we've created a Report that uses three queries that each have in common
a date that is prompted to the User.

However when we make it to the AutoSearch dialog the same date is prompted
for three times.

I was wondering seeing as these dates are all going to be the same if it's
possible to only prompt the User once for the date?

Thanks for all help here (a non-RAP solution is preferable).

Regards,
Nigel Huband.

Comments

  • edited November 2002
    Are you using DADE or data access components on the form? I'm guessing that
    you are using DADE. The best way I can think of at this point is to create
    one autosearch field, and two regular non-autosearch search fields in the
    dataviews. Then you'll only see one date search field in the autosearch
    dialog. Then you can set the search criteria values in code on the
    dataview's SQL objects for the other two fields based on what the user
    entered for the lone autosearch date field. Here is an example of
    extracting the TdaSQL object at runtime without using RAP. Use the
    OnGetAutosearchValues event of the report to set the values as shown in the
    autosearch demos.

    http://www.digital-metaphors.com/tips/ExtractSQLObject.zip


    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited November 2002
    Thanks Jim.

    However the Client is able to generate Reports thus removing the option to
    copy the dates across.

    Is it possible to be done in RAP?

  • edited November 2002
    Then you'll need to create a RAP pass through function. There are examples
    of creating RAP pass through functions in the RAP tutorials and demos.


    Cheers,

    Jim Bennett
    Digital Metaphors

This discussion has been closed.