Prev: RSActivate
Next: rsErrorOpeningConnection
From: John Smith on 31 Aug 2005 11:16
I am a newb in Reporting services and need to create a parameterized report.

I have already created a report parameter and now I need to apply it in the
report output. I assume that I have to somehow pass this parameter to the
dataset that is used to display the data. I am putting =
'Parameters!prmState.value' in the filter column of the field that need to
be filtered but it does not work. Please help.

Thanks.


From: C.M on 31 Aug 2005 11:28
On the data tab press the "..." right next to the data set name . A new
dialog box will pop up. The 4th tab in the box says "Parameters". This is
where to import the information to pass along to the SQL code you have in the
report or a stored procedures

"John Smith" wrote:

> I am a newb in Reporting services and need to create a parameterized report.
>
> I have already created a report parameter and now I need to apply it in the
> report output. I assume that I have to somehow pass this parameter to the
> dataset that is used to display the data. I am putting =
> 'Parameters!prmState.value' in the filter column of the field that need to
> be filtered but it does not work. Please help.
>
> Thanks.
>
>
>
From: MJ Taft on 31 Aug 2005 14:03
On the data tab ... add a WHERE clause to your query that says
Where [ColumnName] = @prmState

replace [ColumnName] with the name of your database field you are comparing
and make sure that prmState is the same name that shows as your parameter in
the report parameters

btw - that is if you are using SQL Server ... if you are using some other
database then you may not be able to use that syntax.

"John Smith" wrote:

> I am a newb in Reporting services and need to create a parameterized report.
>
> I have already created a report parameter and now I need to apply it in the
> report output. I assume that I have to somehow pass this parameter to the
> dataset that is used to display the data. I am putting =
> 'Parameters!prmState.value' in the filter column of the field that need to
> be filtered but it does not work. Please help.
>
> Thanks.
>
>
>
From: Stephen on 1 Sep 2005 12:14
try =@prmState in the criteria column of your dataset. parameters in
t-sql need to be prefixed with a "@" even though reporting services
itself drops the @.

 | 
Pages: 1
Prev: RSActivate
Next: rsErrorOpeningConnection