BusinessObjects Board

Simple Prompt

building reports desktopintelligence
#1

HI

I am using BO 6.5.

I have a report which shows Null as well as not null values a column

NOw the user wants a prompt where in he can select either Null or NOt null or All Means user wants to see only null data, or only not null data or both.

I am not able to figure out how to make such a prompt

Thanks

rajx72 (BOB member since 2006-08-02)

#2

Firstly, create a new universe object that tells you whether the column is null or not. The object should be defined something like:

CASE WHEN table.column IS NULL THEN 'null'
     ELSE 'not null' 
END

Create a LOV for this object. It will contain 2 values - null and not null.

Secondly, you need to add ALL into the LOV. This Designer FAQ describes how to do it.

And now use the new object in the condition of the report query and create a prompt for it so the user enters either null or not null or All.

Hope it is clear.

Marek Chladny :slovakia: (BOB member since 2003-11-27)