Post reply

Multi-value parameter: Default Ticks

  • September 4, 2007 at 4:54 am

    #373727

    I need to setup a multi-value parameter where certain specific rows are ticked by default. Any idea how to do this? Thanks.

  • September 4, 2007 at 5:39 am

    #731162

    Yes. This is fairly straight forward in 2005.

    Create a dataset with just the selected values in.

    In the Report Parameters dialog select the appropriate parameter.

    Change the option for default values to "From query"

    Select the dataset you created above, and set the value field (should be the values not the labels).

    That should do it.

  • September 4, 2007 at 6:46 am

    #731187

    Well, I wasn't convinced at first, but I've just tried it and it does work! Many thanks, I'm sure that would have taken ages to track down.

    What would be even better though is to do this using just one dataset...

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

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