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 2008 Forums
 Analysis Server and Reporting Services (2008)
 SSRS 2008 matrix report

Author  Topic 

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2011-08-10 : 08:35:17
Hi

Is it possible to add row group in between two column group SSRS 2008 matrix report?

T.I.A

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-10 : 09:03:28
sorry didnt get that. can show a screen shot of how you want output?

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

Go to Top of Page

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2011-08-10 : 09:17:38
Hi
Not able to take screen shot but i am pasting excel out put

Dept ID1 Dept ID2 Dept ID3 Sal Wrd Thin Get Dept ID1 Dept ID2 Dept ID3
EMP Details Join1 XXX XXXX Kpo bgyu
Join9 Join12 XXXX kop
Join10 Join98 XXX fthy

column group is on dept ID
please help me out.

T.I.A
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-10 : 09:32:55
sorry the formatting is awful...really not able to make out how output format is

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

Go to Top of Page

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2011-08-10 : 10:59:07
Sorry for deplay repiled.

Can i split column group. i.e first column (value getting dynamically) group by deptdetails and then few calculated columns and again column group of deptdetails.

this is customised format required.

T.I.A
Go to Top of Page
   

- Advertisement -