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
 Development Tools
 Reporting Services Development
 matrix issues

Author  Topic 

gavakie
Posting Yak Master

221 Posts

Posted - 2010-04-26 : 18:19:09
I have a simple matrix I guess, how do I add the row name off of the columns that are grouped by?


i have
3 columns that are grouped by then the data in three other data columns, how do i add the column headers to those data columns?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-04-27 : 00:50:04
can you show a screenshot? perhaps that would make clear what you're asking for

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

gavakie
Posting Yak Master

221 Posts

Posted - 2010-04-27 : 09:17:51
http://s816.photobucket.com/albums/zz83/gavakie/?action=view¤t=matrix.jpg
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-04-27 : 10:54:02
isnt it enough to use group header?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

gavakie
Posting Yak Master

221 Posts

Posted - 2010-04-27 : 11:03:09
Well there are three different groups, it only gives me the option to add one name in the box above the three unless im missing something.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-04-27 : 11:21:58
quote:
Originally posted by gavakie

Well there are three different groups, it only gives me the option to add one name in the box above the three unless im missing something.


isnt the value to display coming from field which you group upon?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

gavakie
Posting Yak Master

221 Posts

Posted - 2010-04-27 : 11:27:48
Not in the matrix, it gives me one box for all three columns. It wont let me add a column name for each grouping. Atleast not that I can find.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-04-27 : 11:58:13
nope. i was asking whether the values to display are available from the field in dataset used for grouping

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

gavakie
Posting Yak Master

221 Posts

Posted - 2010-04-27 : 12:46:45
oh, no they arent! sorry about that.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-04-27 : 12:48:01
quote:
Originally posted by gavakie

oh, no they arent! sorry about that.


then where do you get values from?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -