Got a requirement for creating fancy report in SSRS 2008. it's in the matrix format, but instead of normal columns that grows to the right, they want something like stepped rows for column
Something like this:
col1
col2
col3
row1
row2
row3
instead of the standard matrix
col1 col2 col3
row1
row2
row3
Can anyone suggest to me how to do this? Have no idea how to start :(
At the end to do this I give up on using matrices and use subreports instead.
I separate the report into three pieces. one main report with two subreports. the header is main report, two subreports is in left and right, all using tablix. the main report has some custom code added for accumulating spaces and achieving desired "stepped" effect
it's possible to achieve better visual design if we use background image for the lines instead, but this will have to do for now :)
