Creating search criteria runtime.

rbuser

Hello everyone,

I'm trying to add an extra search criteria to a report when it is being
executed. I don't want it to be an autosearch field, i.e. it does not need
to be shown on the autosearch form with the other autosearch criteria of the
report.

How do I do this? For now I use the method CreateAutoSearchCriteria, but
this results in a real autosearch criteria being shown on the autosearch
form. That I don't like to happen...

I'm using Report Builder 6.03 with Delphi 5. It's old, I know.

Thanks,

Arnaud de Klerk
IKM Engineering B.V.
Gouda
The Netherlands

nardmoseley

One option is to use the BeforeAutoSearchDialogCreate to set
Report.ShowAutoSearchDialog to false.

RB 9 includes a new TdaSQLBuilder class that provides a runtime interface
for manipulating the TdaSQL object programmtically.


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

rbuser

Hello Nard,

Well, I'd like the autosearch form to be shown (there are other
autoserachfields), but without the criteria I add at runtime. So setting
ShowAutoSearchDialog is not an option.

RB9 surely will help, but is not an option either, at the moment.

Do you have any other suggestions? Again, I'm looking for the solution to
add criteria runtime to a report, which do not show on the autsearch form.
However, the autosearch form needs to be available, with the autosearch
fields set at design time.

Thanks,

Arnaud de Klerk
IKM Engineering B.V.
Gouda
The Netherlands

nardmoseley

Below is an example that uses the older technology.

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




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