Non AutoSearch Filters
I need to know how to evaluate and test for search criteria that exist in a
report but is Not AutoSearch criteria.
I pass autoseach values to the report assuming the user has not already
preset a search criteria. For example, I will pass a date range to the
CompletedDate field provided the user has not alreaded entered a Non
AutoSearch criteria such as CompletedDate is Blank which clearly means they
want the report to include all records where there is no CompletedDate.
I want to be able to iterate through the Non AutoSearch search criteria and
test for this. I can do it throught the AutoSearch items but have not
figured out how to do it through the others.
Thanks,
Bob Tucker
report but is Not AutoSearch criteria.
I pass autoseach values to the report assuming the user has not already
preset a search criteria. For example, I will pass a date range to the
CompletedDate field provided the user has not alreaded entered a Non
AutoSearch criteria such as CompletedDate is Blank which clearly means they
want the report to include all records where there is no CompletedDate.
I want to be able to iterate through the Non AutoSearch search criteria and
test for this. I can do it throught the AutoSearch items but have not
figured out how to do it through the others.
Thanks,
Bob Tucker
This discussion has been closed.
Comments
The QueryDataView's TdaSQL object contains all of the search critieria
(whether autosearch or not).
The following example shows to extract the TdaSQL object from a DataView and
add/modify its search criteria.
http://www.digital-metaphors.com/tips/AddSearchCriteria.zip
Cheers,
--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com