Print Page - Value prompt to select for null data item value

Title: Value prompt to select for null data item value
Post by: Todd129 on 29 Jan 2013 11:23:14 PM

Hi there --

I'm trying to develop a pulldown static Value prompt that will filter a list report for all items where [Data Item] IS NULL.

I've tried using a CASE statement in the filter, that bombed. I tried to have the pulldown pass the text 'IS NULL' to the filter and that didn't work either.

Any other suggestions from the community that I might try?

Many thanks!

Todd

Title: Re: Value prompt to select for null data item value
Post by: srinu1253 on 30 Jan 2013 12:02:00 AM

keep Blank in the use value of the Prompt and try to filter it by equating to the Data item..

Title: Re: Value prompt to select for null data item value
Post by: Todd129 on 30 Jan 2013 12:03:37 AM

Thanks for your post! I was finally able to get this to work using the below filter

Case
WHEN (?pFinalcheck?)=1 THEN ([APPRV_#5_FINAL_CHK_CMPLTD_DT] IS MISSING)
ELSE NULL
END

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Todd129 on 29 Jan 2013 11:23:14 PM