Post reply

How to create a combo dropdown

  • June 28, 2013 at 7:06 am

    #395056

    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.

  • June 28, 2013 at 9:39 am

    #1628330

    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


    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne

  • July 2, 2013 at 12:05 am

    #1628905

    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.

  • July 2, 2013 at 2:05 am

    #1628934

    Hi,

    Here you go:

    http://bit.ly/120bYs9

    Thanks,

    Simon


    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne

  • July 9, 2013 at 6:52 am

    #1630773

    :laugh:

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply