Alerter : Need to supress Row While Break Applied

building reports webintelligence
1

Hi,
We are need to supress row with Alerter along with Break.

e.g.

Column is [ranges] & Break applied on it.

5>1
A Amt
0.1 2345
0.2 45678
0.3

10>5
B Amt
0.1 2345
0.2 45678
0.3 123
0.4

Now Need to supress the Last Row that is null. can we do that.

Thanks
Gunjesh

gunjesh (BOB member since 2008-09-15)

2

I understand that this it is irrelevant if you have a break applied or not. You want to suppress a row if the measure is null right? Change your measure format such that NULL values are displayed as 0 or some number which you are sure will not come up as your measure value (I have faced some strange issues when I try to create an alerter directly by checking if it if NULL or not and hence this suggestion). Create an alerter that checks if your Measure display value is 0 or not. If it is 0, change the font of the entire row to white(if your background color is white). Also change the borders such that they dont show up. You cannot suppress a row based on an alerter, you can only hide it with workarounds.

nithya_raj (BOB member since 2007-02-03)

3

Hi,
Thanks a lot. That is true. But any solution to supress rows.
with or without alerter.

Regards
Gunjesh

gunjesh (BOB member since 2008-09-15)

4

No, you cannot make a row dissapear based on conditions, only hide it… :nonod:

nithya_raj (BOB member since 2007-02-03)