Why does optional filter on prompt page change to required when using data item?

[piro299]

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,

Code Select Expand


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

[Lynn]

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.