Using parameters with custom sql queries

rbuser

I'm putting together a report using Report Builder. Due to the complexity of
the SQL query that is required to obtain the data for the report I have had
to write the query by hand, and as such the Visual Designer won't touch it.
For simpler reports I have been able to use the Search tab of the Query
Designer to get Report Builder to prompt for parameters (client id, for
example) but because I have edited the SQL I am unable to access this tab.

Is there a another way to force Report Builder to prompt the user for
parameters to use in the query? I am running the report from Report
Explorer.

Thanks

nardmoseley

Here is an example manually editing the SQL and implementing auto search.
The example contains Delphi code, but can be ported to RAP code.

www.digital-metaphors.com/tips/EditSQLAndAutoSearch.zip

RB 11 will include support for accomplishing this without writing any code


--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com