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: Thursday, August 21, 2014 2:40 AM
Points: 593, Visits: 1,082
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: Wednesday, August 13, 2014 9:51 AM
Points: 702, Visits: 2,176
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: Thursday, August 21, 2014 2:40 AM
Points: 593, Visits: 1,082
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: Wednesday, August 13, 2014 9:51 AM
Points: 702, Visits: 2,176
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