How to hide the rows based on Null values in measure object

building reports desktopintelligence
1

Hi,

I have a situaton where i need to hide the rows where ever i get nullvalues in the measure object.
I tried by using filters and able to filter it,but it is filtering to a paricular prompt or table .When users selects diffrent prompt, a new data will be coming in the report and null values are visible again.

can u please suggest me how to filter the nullvalues globally.

panduswapna (BOB member since 2008-08-01)

2

Are you having many tables/blocks? Are you able to apply a global filter? Or did you try to filter out the NULL values in the query itself by Is Not NULL operator?

Jansi :india: (BOB member since 2008-05-12)