Post reply

Allowing Nulls when using Multi-value parms

  • August 21, 2006 at 11:21 am

    #116065

    I'm guessing that if you choose to use the multi-value option for a report parameter that you can't also set the option to allow null values? I get an error message that says, "The properties for the currently selected item are not valid. Please correct all errors before continuing."

    So how do you allow for optional parameters when using multi-value parms, or can you?

    Thanks

    -A.

  • August 24, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • August 24, 2006 at 8:55 am

    #656603

    If you are using a query or stored procedure to fetch the list of values to select, add a Union statement to add the null to the result set.  I don't know of a way to do it with a list coded into the report. 

    Select ListData from ListOStuff

    union

    Select null

  • August 24, 2006 at 9:02 am

    #656609

    That's what I was doing, however I've run into the fact that if you use a multivalue parameter, it won't let you leave the default value of null for the parameter. I prompts you to supply a value for that parameter when you click the view report button.

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

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