Using Run-time parameters
Hi,
I am a very new user of ReportBuilder so please accept my apology if this is
quite basic.
Can somebody please point me in the right direction for information/guidance
on how to use a run-time parameter in a report? I have built a report which
the end-user wants to be able to run for a date-range which will be
specified at run-time.
I have set up a search against the Data which works fine when I enter the
actual dates(eg. 09/03/2004, 13/03/2004) but I dont know how to enter the
parameter names. I have tried :StartDate, :EndDate but get an error message.
Thanks,
Brian Egerton
begerton@tasman.net
I am a very new user of ReportBuilder so please accept my apology if this is
quite basic.
Can somebody please point me in the right direction for information/guidance
on how to use a run-time parameter in a report? I have built a report which
the end-user wants to be able to run for a date-range which will be
specified at run-time.
I have set up a search against the Data which works fine when I enter the
actual dates(eg. 09/03/2004, 13/03/2004) but I dont know how to enter the
parameter names. I have tried :StartDate, :EndDate but get an error message.
Thanks,
Brian Egerton
begerton@tasman.net
This discussion has been closed.
Comments
You're going to want to check out the AutoSearch feature of ReportBuilder.
Using AutoSearch, there is no need for parameterized queries, ReportBuilder
will handle the filtering of datasets for you. You can activate an
autosearch criteria manually at runtime by entering values into a dialog or
automatically with pre-defined values. Please see the AutoSearch demos in
the \RBuilder\Demos\5. AutoSearch\... directory for some good general
examples. You will ultimately want to probably use AutoSearch in DADE which
can be activated in the Search tab of the query designer.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
where can the end user find details of how to do this, I
cannot find autosearch or search anywhere in the Learn Reportbuilder
documents?
Using Autosearch in the end-user environment is very similar to enabling it
through code. (only easier). You can make any "Search" expression into an
AutoSearch expression by checking the Autosearch checkbox. Other than that
it will work the same as the examples given in the \RBuilder\Demos\5.
AutoSearch\... directory. Unfortunately, there is not much AutoSearch
documentation for the end-user, so you will need to relay this information
to your end-users so they can create an Autosearch criteria on their own.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com