locked
Default Values on Parameters RRS feed

  • Question

  • I have created a report within ssrs 2005.

    I have 3 sets of parameters where we allow the user to select a number of items within the parameter before the report is run.

    I wanted to set the default of all the parameters to SELECT ALL so they will just need to click on VIEW REPORT. I have set the default of two of the parameters successfully... by going within REPORT PARAMETERS and selecting FROM QUERY radio button within Default Values... I selected the correct Dataset and the Column name...

    But when I deploy the report... one of the parameters default values isn't selected... what am i doing wrong

    Wednesday, May 18, 2011 7:43 AM

Answers

  • the problem was resolved by removing null values with the dataset for the parameter
    • Marked as answer by SQL_1980 Wednesday, May 18, 2011 7:57 AM
    Wednesday, May 18, 2011 7:49 AM