End User Search Criteria

rbuser

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.

digitalmetaphors

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

rbuser

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?

digitalmetaphors

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