locked
Default Values in Multiselect Parameter RRS feed

  • Question

  • Hey all:

    New to Report Builder (3.0).

    I have 4 Parameters.  All of them are mutiselect and eash gets its values from a dataset (each parameter has its own dataset).  On each parameter i have set the dafault values to be the same dataset as the source dataset (I read that this how you default to a 'Select All' state).  This is only working for one of the parameters, the other 3 are not defaulting.

    The SELECT statements are a simple:

    SELECT DISTINCT
         <<table>>.<<column>>
    FROM
         <<table>>
    ORDER BY
         <<table>>.<<column>>

     on all datasets.

    Any ideas as to what could be causing this?

    Thanks in advance

    Ed

    Friday, January 6, 2012 4:49 PM

Answers