locked
Multiple Default Values of Parameter RRS feed

  • Question

  • I have a report parameter that will either have 1 value to pick from, or multiple values to pick from depending on who is logged in.  I want to be able to set the default value to the first result that is returned in the dataset.  Is there a simple way to do this without making a new dataset?



    Thursday, August 3, 2006 8:15 PM

Answers

  • Hi,

    you either need a new dataset or a static value for the default property. You can´t use the dataset as a expression to get the first value of the dataset.

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
    Thursday, August 3, 2006 9:10 PM