Matrix report problem.. - SQL Server Forums

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 report problem..

Author

Topic

keyursoni85
Posting Yak Master

233 Posts

Posted - 2010-08-20 : 09:33:39

Hi,

I have data output like..


CatID  CatName PropertyDesc PropertyValue
1     Category1 -- --
1     Category1 Cat1Prop1    9393
1     Category1 Cat1Prop2    444
1     Category1 Cat1Prop3    3434
2     Category2 --           --
2     Category2 xyzprop      894489
3     Category3 --           --
3     Category3 teste        33333
3     Category4 --           --

And matrix reports works well with below output
[code]
           Cat1Prop1  Cat1Prop2  Cat1Prop3  Cat1Prop4   xyzprop ... and more..
Category1   9393        444       3434       
Category2                                                894489
Category3
... and so on

Now i have multiple columns like category columne..
I can add those columns above category column but i am not able to give seperate header name ..
when i click on header for newly added columns only one header comes..
please advice/help..

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-08-20 : 13:34:20

Didnt understand that. can you post screen shot of issue?

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

keyursoni85
Posting Yak Master

233 Posts

Posted - 2010-08-21 : 03:14:08

Thanks visakh

Actually my problem is..
I created Matrix report ..

I put my matrix on list control and thne give list to page break at end to split up in different excel sheets..

Below is sample image..
[img]
http://www.simple-talk.com/iwritefor/articlefiles/278-SSRSPt2_09.gif
[/img]

My output is like..
As i have showed my sample data output..
i have multiple columns in place of



catid  CategoryName  Cat1Prop2  Cat1Prop3  Cat1Prop4   xyzprop ... and more..
1      Category1                  9393        444       3434       
2      Category2                                        894489
3      Category3
... and so on

I want to give column name for as mentioned above..
i have multiple column on place of Catid, CategoryName.. but matrix allows only one headername for those multiple columns..

How above things help you to make it clear : )

Thank you ..
waiting for your reply..

keyursoni85
Posting Yak Master

233 Posts

Posted - 2010-08-23 : 06:41:31

Thanks for all of your's help
See below link if no one knows about..
http://www.sqldev.org/sql-server-reporting-services/row-headers-in-matrix-report-4469.shtml

Thank you visakh..
i was waiting for your answer from last two days.. :)

Thank s all

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources