How to create a combo dropdown

  • 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.

  • 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

  • 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.

  • 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

  • :laugh:

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

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