Formatting Help (Break?)

[DugzDMan]

Does anyone know how to merge two cells in BO? I've tried using inserting break, then removing the headers and footers, but it won't work right when the items I need to merge are in the body of a table. It works fine for items in the 1st column, but I can't get it to work here.

I have a report like this:

1       2     3     4      5
current 1     0     11     11
current 2     11    0      11
31 - 60 1     0     0      11
31 - 60 2     0     0      11
61 - 90 1     0     0      11
61 - 90 2     0     0      11

I need to format it like this:

1       2     3      4      5
current 1     0     11     11
current 2     11    
31 - 60 1     0     0      11
31 - 60 2     0            
61 - 90 1     0     0      11
61 - 90 2     0

Basically, rows 1 (time frame) and 2 (jurisdiction) are the breaks on the data. Row 3 is the data broke down by time frame and jurisdiction. Row 4 is the total of row 3 for each time frame but all jurisdiction. Row 5 is the total for all time frames.

Any ideas???

Thanks!!!!

 

[RohitMathur]

Hi,

I don't get a clear picture of how you are calculating the total of row 3. Also I'm not clear about what your definition row. Is that those 1,2,3,4,5 on the top you call the rows. Even otherwise you can't merge cells in the body of the table but you can in the Table Headers.


Rohit

 

[DugzDMan]

The headers 1, 2, 3, 4, and 5 were just for reference purposes.

Row 3 is a total broke down by time frame (current, 31-60, etc. and jurisdiction 1 or 2) Row 4 is a total just by time frame (jurisdiction doesn't matter). Row 5 is a total of all time frames (grant total).

I did figure out a way to get around this. Since I have the jurisdiction in every table, I used the odd function and an if statement to hide every other entry in columns 4 and 5.

Like this:

If Odd(Column 2) Then Formula

By leaving the else off, it doesn't display anything when even.