Autosearch & Parameters
Tired of the standard Autosearch dialogs I've created several forms (one for
each report) with which the end-user can define the report query parameters
(from customer, to customer, from date, to date, from supplier, to
supplier,..., etc).
All the reports are RTM files. The user choose, from the list of rtm files,
the report that he want and the program displays the related parameter form
via the Application.FindComponent mechanism. The form has the same name of
the rtm file (without the .rtm extension). So, with the TdaSQLBuilder the
program adds the SearchCriteria.AddAutoSearch(...), sets the
Report.ShowAutoSearchDialog = False and print the parametrized report. All
work fine even if I don't know if this is the best method to do this. Any
comment about will be appreciated.
My question is:
How can I print into the report the parameters ? I want to view, for
example, into the "CUSTOMER ACCOUNT STATUS" report, the parameters "From
date: StartDate" "To date: EndDate" where StartDate and EndDate are the
parameters choosed by the user.
Help me, please.
Robert
each report) with which the end-user can define the report query parameters
(from customer, to customer, from date, to date, from supplier, to
supplier,..., etc).
All the reports are RTM files. The user choose, from the list of rtm files,
the report that he want and the program displays the related parameter form
via the Application.FindComponent mechanism. The form has the same name of
the rtm file (without the .rtm extension). So, with the TdaSQLBuilder the
program adds the SearchCriteria.AddAutoSearch(...), sets the
Report.ShowAutoSearchDialog = False and print the parametrized report. All
work fine even if I don't know if this is the best method to do this. Any
comment about will be appreciated.
My question is:
How can I print into the report the parameters ? I want to view, for
example, into the "CUSTOMER ACCOUNT STATUS" report, the parameters "From
date: StartDate" "To date: EndDate" where StartDate and EndDate are the
parameters choosed by the user.
Help me, please.
Robert
This discussion has been closed.
Comments
1. The autosearch dialogs are completely customizable so if you would like
to register your own dialog, it will automatically be used with
ReportBuilder. See the example located in the \RBuilder\Demos\5.
AutoSearch\4. Custom AutoSearch Dialog\... directory for more information.
2. After the AutoSearch field has been created, you can access it's value
using the Report.AutoSearchFieldByName routine. This will give you access
to the TppAutoSearchField object and you can use the Value property to show
the parameter on your report (with a TppLabel if you would like).
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com