Passing Autosearch parameters
I am using a report template stored in a database. The template contains an
autosearch field that displays a dialog requesting a value when the report
is run. The report is connected to the database via the ReportDesigners
DatabaseName property. However, I want to call the same template from my
application and pass the field values directly so the autosearch dialog does
not pop-up.
I know how to set the ppReport1.template.DatabaseSettings.Name property but
I would have thought code like should work:
ppReport1.template.DatabaseSettings.Name := 'Docket';
ppReport1.template.LoadFromDatabase;
if assigned(ppReport1.AutoSearchFieldByName('JobID')) then
ppReport1.AutoSearchFieldByName('JobID').AsString := '46669';
ppReport1.Print;
How do I do this? The AutoSearchFieldByName returns the Field ok but the
value properties are read-only! Also the OnGetAutoSearchValues event seems a
bit weird as it doesn't get a value at all but merely provides an
opportunity to provide such values to be used in the query that provides the
data for the report. In my case there is no such query as I choose to handle
the entire think in the report template.
The demo examples don't seem to cover this particular issue. Any thoughts?
Thanks in advance
Paul van Dinther
autosearch field that displays a dialog requesting a value when the report
is run. The report is connected to the database via the ReportDesigners
DatabaseName property. However, I want to call the same template from my
application and pass the field values directly so the autosearch dialog does
not pop-up.
I know how to set the ppReport1.template.DatabaseSettings.Name property but
I would have thought code like should work:
ppReport1.template.DatabaseSettings.Name := 'Docket';
ppReport1.template.LoadFromDatabase;
if assigned(ppReport1.AutoSearchFieldByName('JobID')) then
ppReport1.AutoSearchFieldByName('JobID').AsString := '46669';
ppReport1.Print;
How do I do this? The AutoSearchFieldByName returns the Field ok but the
value properties are read-only! Also the OnGetAutoSearchValues event seems a
bit weird as it doesn't get a value at all but merely provides an
opportunity to provide such values to be used in the query that provides the
data for the report. In my case there is no such query as I choose to handle
the entire think in the report template.
The demo examples don't seem to cover this particular issue. Any thoughts?
Thanks in advance
Paul van Dinther
This discussion has been closed.
Comments
field values are set, but no dialog is ever displayed....
Cheers,
--
-
--
Tom Ollar
Digital Metaphors Corporation
http://www.digital-metaphors.com
info@digital-metaphors.com