Hello,
I have a query for my prompt page in which I define a static data item with a value like 'hide value'.
This data item is related to an optional filter on the prompt page. The name parameter in the filter is named prmHideValue
When I use prmHideValue in a second query for a list,
If (?prmHideValue? = '') then ('') else ([Query2].[Data Item1])
the optional filter on the prompt page change to required. Why?
How do I have to use the prmHideValue in the Data Item, so it stays optional?
Many thanks in advance.
Sven
Whenever you reference a parameter in a data item it has to become required. The expression cannot be validated and the SQL cannot be generated unless there is a value provided, hence it is required. You can give the parameter a default value which won't make it optional but functionally would achieve the same thing.