Hiding blank rows

building reports webintelligence
1

Hi Guys,

I am designing one ad-hoc report that needs to show Person Name, Address Line 1, Address Line 2, City State Zip Code. For many person, Address Line 2 is blank. We would like to hide this row when this is blank and move up city State Zip row.

Format of this report is like:

Person Name
Address Line 1
Address Line 2
City State Zip Code

How can i hide this row when this is blank in WebI xi r2.

Thanks,
J WOOD

wood :nepal: (BOB member since 2006-06-05)

2

Apply filter on that dimension, set operator as"is not null" then it automatically filters out the value which is null.

madhu kothamasu :us: (BOB member since 2007-07-31)

3

The address Line 2 doesnot have null value in database. If no information is there on this column, it is simply blank in our SQL Database. So if i use IsNull() function, it doesnot make any sense.

I appreciate anyone’s help on this.

Thanks,
J WOOD

wood :nepal: (BOB member since 2006-06-05)

4

Try couple of these,

Flag=If Length(Trim([Address 2]))=0 Then 1 Else 0

see if you still get 1 for the above flag. If you get then you can filter out Flag=1

KhoushikTTT :us: (BOB member since 2005-02-24)

5

Y’all are missing the point. :slight_smile: The original poster doesn’t want to filter out the record, they just want the row (meaning a cell in this case) to not be shown if / when there is no address line 2.

Here is an idea. First, combine the two lines of address into one object using a concatenation. Then include a return character only if the second line of address is not null. In pseudo code:

= [Addr Line 1] + if(not(isnull([Addr Line 2])); chr(13) + [Addr Line 2];"")

Then set the wrap attribute on for that cell. I believe that - or something like that would work the best. I didn’t test the formula so the parenthesis probably don’t match but hopefully you will get the idea.

Dave Rathbun :us: (BOB member since 2002-06-06)

6

Thanks Dave. I appreciate your help.

Thanks,
J WOOD

wood :nepal: (BOB member since 2006-06-05)