all groups > sql server reporting services > march 2005 >
You're in the

sql server reporting services

group:

matrix row grouping


matrix row grouping CCP
3/3/2005 11:41:02 PM
sql server reporting services: HI,
Is it possible to have row grouping for each row in a matrix??

Something like

header1 header2
Task1
Section1
Row1 value1 value1
Section2
Row2 value2 value2
Task2
Section1
Row1 value1 value1

When i use a matrix grouping it is producing the result as
Task1 Section1 Row1 value1 value1
Section2 Row2 value2 value2
Task2 Section1 Row1 value1 value1

What i need to get the similiar look and feel as the previous one.....
I could get this design with a table grouping but the columns are populated
dynamically... which is not possible in a table so im shifting to a matrix....


Your help is highly appreciated...

Re: matrix row grouping Chris McGuigan
3/4/2005 1:27:33 AM
Right click the data cell and do 'Add Row'.
You are effectively creating two rows per record.

Chris



[quoted text, click to view]
Re: matrix row grouping CCP
3/4/2005 3:39:03 AM
Thanks chris for ur reply...
When i add a row like that..its repeating column wise i want it to repeat
row wise....

Thanks,


[quoted text, click to view]
Re: matrix row grouping Chris McGuigan
3/4/2005 4:04:45 AM
I'm with you now!
It's possible but it's a bit of a hack.

Basically you need to squeeze two text boxes into the row header, you
can do this with 'rectangle' controls.

Create a rectangle OUTSIDE the data region, create two textboxes inside
the rectangle, laid out the way you want them. Set their values to the
appropriate fields.
Cut and paste the rectangle into the row group cell on the matrix and
Bingo! it should work.

The downside to this method is it can be quite fiddly to get the
formatting just right but you can do it.

To try and explain it graphically, the structure of your matrix should
be something like this.


+--Matrix--------------+----------+
| | |
+----------------------+----------+
|+==Rectangle=========+| |
||+--Textbox1--------+|| |
||| ||| |
||+------------------+|| |
||+--Textbox2--------+|| |
||| ||| |
||+------------------+|| |
|+====================+| |
+----------------------+----------+

Chris



[quoted text, click to view]
Re: matrix row grouping CCP
3/5/2005 1:23:05 AM
Thanks Chris,
That worked...


[quoted text, click to view]
AddThis Social Bookmark Button