Drop Downs as Parameters

Jeremiah · May 25, 2016, 1:32pm

Hello,

I am using the 2.2.5 version of Report Server.

Is there a way to have Drop Downs work as Parameters? I have Crystal Reports that use Drop Downs for Parameter Selection. When I load it into Report Server I only get the parameter option as a Type in field.

Arno_Mittelbach · May 25, 2016, 2:50pm

Hi Jeremiah,

you would need to use a datasource parameter for this. Have a look at https://reportserver.net/en/guides/admin/chapters/Working-with-Parameters/ (in particular Section 6.3.6).

Regards,
Arno

Jeremiah · May 25, 2016, 3:07pm

You…Are…A…
Life (project) Saver!

Thank you!

Glandike · May 25, 2016, 3:15pm

For note: you can simply write next query to the default RS database:

select '1'
union all
select '2'

And obtain the data that you want

Arno_Mittelbach · May 25, 2016, 6:46pm

Glad I could help .. in case you find the time, it would be great if you could write a review on your experience with RS. For example on Gartner or on G2Crowd.

Cheers,
Arno