how to...Parameters for database saved template reports

rbuser

Hello,

I have been trying to find out more about how to pass parameters to reports
saved as templates on the database. So far I have found a few references
but I am lost.
Does anybody know of a document/ tip/ that will give me an overview of how
it works and how can I implement them?

Thanks,

Isi R.

nicocizik

Hi Isi,

There are two types of parameters that can be used with Reports. AutoSearch
Parameters and Report Parameters. AutoSearch Parameters can be passed to a
report filtering the data that gets displayed in the report. Report
Parameters are paramters that can be passed from outside the report to
manipulate in in certian ways.

What exactly are you trying to accomplish using parameters? Please
elaborate on what exactly you are trying to do and I'll help you find the
right solution using ReportBuilder.

--

rbuser

Hi Nico,

I have a few reports that I would to stored in a database table as
Templates. These reports get data from stored procedures. Each report does
have a new method call InitializeData in which I pass parameters into the
stored procedures, then execute them and then I print the report.

I need to be able to load the report from template and somehow pass in a
date, a user id, etc to the stored procedures and then print the report.
That's all....


Isi r.

nicocizik

Hi Isi,

I would recommend using a custom Autosearch dialog to retrieve the needed
values from the users (ie. date, user_id). Then you will be able to use the
Autosearch event which fire before the report prints to access your stored
procedures with the values entered. See the AutoSearch demos in the
\RBuilder\Demos\AutoSearch\... directory for examples on how to use
ReportBuilder's Autosearch capabilities.

--