SSRS: collapse tables & matrix

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

SSRS: collapse tables & matrix

Author

Topic

hanavan
Starting Member

25 Posts

Posted - 2008-09-25 : 16:31:01

I'm trying to collapse tables & matrixes. It works but only the data is hidden but not the actual columns.
I would like to have it the excel pivot table way. So when you collapse the column is gone, and you get a bettter overview.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-26 : 01:58:54

what do you mean by actual columns? Have you given columns in group header? Or is it main columns you're talking about?

hanavan
Starting Member

25 Posts

Posted - 2008-09-26 : 03:22:08

Hello,
I've made a screenshot of the matrix.
I want to move the cross closer to the first column

http://img150.imageshack.us/my.php?image=examplehi1.jpg

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-26 : 03:25:34

Ok. Have you given the toggle visibility property for other columns to be based on first column in cell properties?

hanavan
Starting Member

25 Posts

Posted - 2008-09-26 : 03:43:37

In the second cell I've tried:
properties: hidden + toggle item first cell of matrix
Result: It's hidden, so I don't see any lines but it's not moved to the right

Edit group of second cell:
properties: hidden + toggle item first cell of matrix
Result: Like the screenshot

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-26 : 03:47:41

quote:
Originally posted by hanavan

In the second cell I've tried:
properties: hidden + toggle item first cell of matrix
Result: It's hidden, so I don't see any lines but it's not moved to the right

Edit group of second cell:
properties: hidden + toggle item first cell of matrix
Result: Like the screenshot

You mean entire matrix size not reduce?

hanavan
Starting Member

25 Posts

Posted - 2008-09-26 : 03:52:09

Yes, the matrix doesn't reduce, it's stays the same
I only see a break in the line on top, so the
lines around the cell are hidden but I want the cell
itself to go away.

It should be when it's hidden, everything moves to the left

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-26 : 03:54:58

quote:
Originally posted by hanavan

Yes, the matrix doesn't reduce, it's stays the same
I only see a break in the line on top, so the
lines around the cell are hidden but I want the cell
itself to go away.

It should be when it's hidden, everything moves to the left

Are you using matrix inside some container like rectangle?

hanavan
Starting Member

25 Posts

Posted - 2008-09-26 : 04:05:22

It was inside a rectangle,
when I removed it, it still stays the same.

Can you do it in a matrix, just lett a column
move to the left

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-26 : 04:16:14

what are column & row group applied?

hanavan
Starting Member

25 Posts

Posted - 2008-09-26 : 04:20:10

Row group: first cell, of matrix > Raw materials (in example screenshot)
Column group: first as year and second group on month

example of designer: http://img101.imageshack.us/my.php?image=example2wf6.jpg

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-26 : 05:00:42

see if this helps

http://www.simple-talk.com/sql/sql-server-2005/advanced-matrix-reporting-techniques/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources