Value prompt to select for null data item value

[Todd129]

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

[srinu1253]

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

[Todd129]

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