sql server reporting services: Print Prompted Values in Filter Conditions -- sql server reporting services

Print Prompted Values in Filter Conditions

Aaron Young
3/28/2006 1:18:02 PM

sql server reporting services:

Hi,

I am hoping this is a stupid question but is there any way of printing a
users entry when they are prompted for a filter condition at runtime? For
example, suppose you have a date range filter on a report and you want to
print at the top of the report the date range the user has entered at runtime.

Can this be done in the Report Builder or must it be done in VS?

Thanks in advance,

Re: Print Prompted Values in Filter Conditions

Rodney Landrum
3/29/2006 2:19:24 PM

Hi Aaron,
I will assume this is SQL Server 2005 since you mentioned Report Builder.
Adding the parameter value to the report at runtime is fairly
straightforward. Simply add a textbox to your report header and add the
expression =Parameters!ParameterName.Value so for the date range, add
=Parameters!DateFrom.Value and that should work. I do not think you can do
that in Report Builder but the Business Intelligence Development Studio or
VS for sure.
Rodney
[quoted text, click to view]