We have a report requirement that looks like the following:
|=============================|
|C1 | C2 | C3 | C4 | C5 |
|=============================|
| There | 0 | a | a | a |
| | |----|----|----|
| Is | | b | b | b |
| | |----|----|----|
| a lot | | c | c | c |
| if data |----|----|----|----|
| here, | 1 | a | a | a |
| | |----|----|----|
| more | | | | |
| than | | | | |
| details | | | | |
|-----------------------------|
| a little| 0 | a | a | a |
| | |----|----|----|
| data | | b | b | b |
| | |----|----|----|
| | | c | c | c |
| |----|----|----|----|
| | 1 | a | a | a |
| | |----|----|----|
| | | b | b | b |
| | |----|----|----|
| | | c | c | c |
| | |----|----|----|
| | | d | d | d |
|-----------------------------|
Currently we have to go a few hacks to format it like this (with the lines and rowspans). It is implemented with a bunch of textboxes and lines and is a pain to add columns to or align correctly.
It is not the nicest RDL to maintain and we would rather implement this with a standard table or a couple of tables / matrices.
Does anyone have any tips on how to do this in SSRS 2005?