Using dropdown parameters in SSRS report

reporting-services ssrs-2008
Red Swan picture Red Swan · Jan 31, 2011 · Viewed 64.5k times · Source

I can see the text box for my data set that having the

"select col1 from table name " as query. I want to populate dropdown instead of text box. I have created the parameter for it . what to do?

Answer

Nat picture Nat · Jan 31, 2011

In short

  1. Right click the parameter

  2. Select "Available Values" section

  3. Click the "Get values from a query" option

  4. Select the appropriate dataset and fields

Related questions

How do I format date and time on ssrs report?

on SSRS report I need to show todays date and current time i tried this =FormatDateTime(Now,"MM/dd/yyyy hh:mm tt") but this is not working for me giving an error. Anyone please help me for expression ? I …

Read More
How to get rid of blank pages in PDF exported from SSRS

I have a two-page SSRS report. When I exported it to PDF it was taking 4 pages due to its width, where the 2nd and 4th pages were displaying one of my fields from the table. I tried to set the …

Read More
SSRS Query execution failed for dataset

Have just deployed my Project on to my reporting Server. I have multiple datasets which are referencing views which exist on the db on that server. When I try to go into any report part I am getting this message: …

Read More