Post reply

ssrs 2008 default parameter value

  • August 8, 2016 at 2:18 pm

    #312292

    In a new SSRS 2008, I have a parameter that selects a list of customers based upon an sql statement (no hard coded values).

    I have setup the parameter to be multi-valued so that more than one customer can be selected at one time. However, the user would like all cuatomers to be selected. Thus would you tell me how to accomplish this goal?

  • August 8, 2016 at 2:33 pm

    #1894431

    Use the [Google]Force, young Jedi!

    https://www.mssqltips.com/sqlservertip/3506/set-select-all-as-default-for-multivalue-report-parameters-in-sql-server-reporting-services/

  • August 8, 2016 at 2:34 pm

    #1894432

    In the Parameter window, go to the "Default Values" tab and select "Get values from a query", then use the same dataset and value field as the ones defined in the "Available Values" tab.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • August 8, 2016 at 2:36 pm

    #1894433

    pietlinden (8/8/2016)

    Use the [Google]Force, young Jedi!

    https://www.mssqltips.com/sqlservertip/3506/set-select-all-as-default-for-multivalue-report-parameters-in-sql-server-reporting-services/

    Use the tags, and you might be considered to enter the Jedi Council. 😀

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • August 8, 2016 at 3:08 pm

    #1894435

    Hmm.. that might explain the defective light saber...

  • August 9, 2016 at 8:50 am

    #1894541

    I tried this and this does not help.

  • August 9, 2016 at 9:14 am

    #1894554

    wendy elizabeth (8/9/2016)

    I tried this and this does not help.

    What's this?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • August 9, 2016 at 9:34 pm

    #1894697

    Sorry, my installation of SSRS 2008 and even 2008R2 are both long since gone.

    In 2016 (so this may not work for you), you go to Parameter Properties.

    Check Allow Multiple Values.

    Go to Default Values. Choose "Get values from a query".

    Select the dataset containing the values.

    Then choose the Value field.

    When I did it, all the values I set as default were checked.

    I suppose if you wanted something other than "ALL" to be selected, then you would have to create another dataset with the defaults and point at that for the default set.

    (Testing my light sabre...)

    Here's[/url] the article I loosely followed...

    <severs hand trying light sabre>... oh well! So much for being a Jedi!

Viewing 8 posts - 1 through 7 (of 7 total)

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