End User Parameters

rbuser

Hi,

Complete novice.
Have no Idea how to get the user to choose a date or an ID which is to be
used as a parameter to a report.
ie.

1. We are using the end user designer.
2. We create a report that requires a parameter on the SQL's ie. SELECT *
FROM TABLE WHERE( DATEFIELD = :THEDATE )
3. Before the user can run the report he must populate the parameter
"THEDATE" with his chosen date for the report.
4. How can the user do this without entering Report Designer?

Kind Regards,

Robert.

nicocizik

Hi Robert,

This can be done using the AutoSearch feature of ReportBuilder.

Take a look at the AutoSearch demo located in the \Demos\5.
AutoSearch\1. AutoSearch Field to SQL Params.

This demo shows how to use an autosearch parameter inside a SQL
statement in Delphi. If you are using a parameterized query in DADE,
the same can be done with Report Parameters (linked to an autosearch
field). See the following articles.

http://www.digital-metaphors.com/rbWiki/DADE/Fundamentals/Create_AutoSearch_Parameters

http://www.digital-metaphors.com/rbWiki/End-User/Fundamentals/Report_Parameter_Fundamentals


Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com