Parameters SSRS- BIDS

Question

Parameters SSRS- BIDS

rkaria

Ten Centuries

Points: 1363
More actions
January 5, 2011 at 6:40 am

#388557

I am using BIDs and have a parameter called 'period' and have specifed values from 1 to 12.
my question is how do i related the field 'period' to the what the parameter.
Thanks

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Assuming the parameter named period. The SQL variable will be called @period. You don't need to declare it. Juste use it directly in the query.

SELECT * FROM tbl where period = @period

If the parameter is multi-select then you can directly use in

SELECT * FROM tbl where period in (@period)

If on the other hand you used a stored proc, then the parameter should be auto - created / sent to the proc. If you change the proc, you need to refresh the fields to get the new definition. Also in that case the in trick would not work and you'd have to split the values once in the proc.

rkaria Ten Centuries Points: 1363 More actions · Answer 2

Thank you but it keeps saying error ' Ambiguous column name 'period' '

Any ideas

rkaria Ten Centuries Points: 1363 More actions · Answer 3

its ok, I was writing the wrong field

Thanks for you help

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

No you just needed to say from which table / other object to take the period from.

rkaria Ten Centuries Points: 1363 More actions · Answer 5

yes sorry that is what I meant I was putting the wrong table.

But Ive still got a problem it runs perfectly within qeury designer, but when i actually run th report I get the below error, before I can even enter the parameters. Ive checked the spelling etc..... Any ideas?

"An Error Occurred during local report processing. The definition of the report MW0006 is invalid.

The value Expression for the query parameter @Period refer to a non-exsisting report parameter 'period' "

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 6

Then you need to manually add the parameter to the report. In design mode, if you right click under the footer section of the report you should see a menu option to manager parameters.

rkaria Ten Centuries Points: 1363 More actions · Answer 7

When i right click on the footer i dont have the options for parameters.

But i have dragged the parameter onto the report footer, but still get the error message!! 🙁

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 8

I don't have bids 2008 here so I can't give you a screenshot nor look arount. AFAIK, the parameters are also available in the same treeview as the datasets.