Hi, My report has a Value Prompt to select none, one or more Region.
The original report filter -> [LOCATION_CD] in (?p_region?) -> this works, no problem.
I modified the filter to -> if (?P_region? is not null ) then ([LOCATION_CD] in ?P_region?) else (0) -> this filter expression fails.
An alternate method is to set the default Value Prompt to (0) then I don't need to modify the original report filter. Does anyone know why my modified Value Prompt filter expression is not working?? Thank you in advance.
Because (0) isn't a valid filter expression. Try:
if (?P_region? is not null ) then ([LOCATION_CD] in ?P_region?) else (1 = 1)
Hi rockytopmark,
Thank you ..your solution if (?P_region? is not null ) then ([LOCATION_CD] in ?P_region?) else (1 = 1) works :D
I then changed the expression back to if (?P_region? is not null ) then ([LOCATION_CD] in ?P_region?) else (0) and when I validate it, it's not showing me anymore errors ???
I am using Cognos 8.3 INR version, no patches no far. Is this a Cognos 8.3 stability issue ???