I would like to make a parameter optional. I expected that a filter defined this way would work:
[Namespace].[QuerySubject].[QueryItem] = coalesce(?ParamName?, 'SomeValue')
Unfortunately, if I make the filer optional, it's not used at all. If I make it required, it forces me to answer a prompt for the parameter.
Is there a way to make a parameter optional and specify a default value to use if it's not provided? Where is the UI to manage parameters?
You can include a prompt control on a prompt page or on the report page and then set the default value there. The coalesce would not be necessary in your filter expression.
Thanks, but I don't think that will work. I have 3 filters. I want to require the user to enter a value in at least one of the prompts.