Set Search Criteria

rbuser

I am designing reportss for my client in the end-user environment. I have
multiple queries, all of which need to be run off of the current year. I
know how to get the current yearr but I don't know how to set existing
search criteria (not specified as autosearch) or how to create these
criteria before the report begins.

nardmoseley

You can create search criteria using the Query Tools. Select the AutoSearch
checkbox to control whether the search criteria are autosearch criteria or
just standard search criteria.

To change the search criteria programmatically you need to extract the
TdaSQL object for the DataView and modify the TdaSQL.Criteria[].FieldValue.

Here is a general example of extracting the TdaSQL object

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

Here is an example of applying Now as the search date

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

--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com