sql server reporting services: Passing parameters to a dataset -- sql server reporting services

RE: Passing parameters to a dataset

C.M
8/31/2005 8:28:30 AM

sql server reporting services: 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

[quoted text, click to view]

RE: Passing parameters to a dataset

MJ Taft
8/31/2005 11:03:03 AM

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.

[quoted text, click to view]

Passing parameters to a dataset

John Smith
8/31/2005 11:16:53 AM

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.

Re: Passing parameters to a dataset

Stephen
9/1/2005 9:14:11 AM

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 @.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.