How to vertically merge cells

[2006 IR Open Dicussion]

By: GrzeWal - grzewal

How to vertically merge cells

2006-08-22 07:26

Hi!

 

I have a question wheather it is possible to vertically merge some collumn entries in a report i.e.:

 

let's imagine that there'a a report with some data, where all the collumn headers are static (which kinda' leaves me without a crosstab option here), and rows group according to some category, for example:

 

Report1:

 

|col1 | col2 | col 3 |

|----------------------|

|type1| data11| data111|

|----------------------|

|type1| data12| data121|

|----------------------|

|type2| data21| data211|

|----------------------|

|type2| data22| data221|

|----------------------|

 

As one can see col1 contains non-unique values.

 

I want it to look like that:

Report1_modified:

 

|col1 | col2 | col3 |

|----------------------|

| | data11| data111|

|type1|----------------|

| | data12| data121|

|----------------------|

| | data21| data211|

|type2|----------------|

| | data22| data221|

|----------------------|

 

Please note that I do need borders to appear in the way the Report1_modified depicts.

 

If it weren't for the borders I could naturally use isPrintRepeatedValues="false" for the col1 entries. But since there are those borders I would also somehow need it to stretch to the whole group height.

 

Can anyone give me a hint how to merge those 'cells' from col1 'excel style' and keep them bordered nicely? Prolly there's a good trick to do that.

 

Best regards,

G