Post reply

How to select "Select All" option in drop down by default when report is loaded

  • February 24, 2009 at 8:33 am

    #206212

    Hi,

    I have a report with multi value parameter,so its rendered as a dropdown with check boxes and a "Select All" option at first.

    What i need is to select that by default so that all the values in that drop down are selected.

    I tried assigning default value to that parameter in the Default value in that Report Parameters

    by assigning "(Select All)" or "Select All" but it wont work ,but if its a single value like say ="MN" it selects that value if its in that drop down list properly but does not select "Select All" if tried in similar fashion.

    I also tried assiging the first value in that drop down using say Paramerts!sample.value(0)

    but it gives error saying forward dependencies not allowed etc.

    Please help with any clue

    Thanks & Regards

    Nitin 🙂

  • February 24, 2009 at 2:22 pm

    #949638

    There is a way to do that.

    In Report Parameter properties ,select the Default Values and choose the Option Get Values from Query.

    Select the dataset and value field. Remember to check the Parameter type as Allow Multiple values.

  • February 25, 2009 at 12:06 am

    #949807

    Hi,

    Got the solution.

    If we bind the parameter "Default Value" with the same values as which is used to populate that parameter (same dataset or new one with same columns) then all values in that parameter are automicatically selected (with Select All option too ticked)

    Thanks & Regards

    Nitin

Viewing 3 posts - 1 through 2 (of 2 total)

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