ReportServer Forum

Jeremiah

Member

Registered: 2016-04-07

Drop Downs as Parameters

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

datenwerke

Registered: 2012-02-14

Re: Drop Downs as Parameters

Hi Jeremiah,

you would need to use a datasource parameter for this. Have a look at https://reportserver.net/en/guides/admi … arameters/ (in particular Section 6.3.6).

Regards,
Arno

Jeremiah

Member

Registered: 2016-04-07

Re: Drop Downs as Parameters

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

Thank you!

Glandike

Member

Registered: 2015-11-10

Re: Drop Downs as Parameters

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

datenwerke

Registered: 2012-02-14

Re: Drop Downs as Parameters

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

Thank you!

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