Parameter Problem

[JohnOB]

I am quite new to reporting services having used CR in the past, and have almost completed my first report.

My problem is selecting my parameters. I want the user to enter our unique PropertyID in the parameter field, and for the report to show only the values for that Property. I can get the parameter field to appear and enter the PropertyID, however when the report runs it shows all records. It is as though I need to tell the report to select only the value entered in the parameters field, but can't work out how to do this.

In CR I would create the parameter then in Select Expert would choose "Where PropertyID = ParameterName" but can't work out how to do similar in Reporting Services.

Thanks

John




"Stupid isn't not knowing the answer, it's not asking the question

 

[JohnOB]

Think I worked this out in the SQL code I entered "WHERE "Proeprty.PropertyID" = @ParameterName

Thanks

"Stupid isn't not knowing the answer, it's not asking the question