Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to create a combo dropdown Expand / Collapse
Author
Message
Posted Friday, June 28, 2013 7:06 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 6:03 AM
Points: 588, Visits: 1,061
How to create a combo drop down for parameter in SSRS report? I have created a SP parameter for the same and it is available as parameter.
Post #1468536
Posted Friday, June 28, 2013 9:39 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 4:35 AM
Points: 702, Visits: 2,172
Hi,

Go to the properties of your parameter, select Available Values from the left, then select the Get values from a query radio button, or specify values. Select the dataset, value and label etc.

Select default values on the left hand side and set one if you so wish.

That's about all there is to it. Let me know if you get stuck.

Thanks,


Simon




MCSA: SQL Server 2012
Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne
Post #1468593
Posted Tuesday, July 2, 2013 12:05 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 6:03 AM
Points: 588, Visits: 1,061
Hi..Thanks for the reply. It would have been good if you posted a web link for the same..where it is depicting the same..for my easy understanding.
Post #1469299
Posted Tuesday, July 2, 2013 2:05 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 4:35 AM
Points: 702, Visits: 2,172
Hi,

Here you go:

http://bit.ly/120bYs9

Thanks,


Simon




MCSA: SQL Server 2012
Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne
Post #1469334
Posted Tuesday, July 9, 2013 6:52 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 24, 2014 1:50 PM
Points: 532, Visits: 448
Post #1471590
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse