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.
| Author |
Topic |
|
learntsql
524 Posts |
 Posted - 2009-07-20 : 02:12:48
|
| Hi ALL,I have two row groups in my matrix reportone for Area and another for Totalbut total should be displayed again as per category wise those are dynamically generated assume we have three categories now.how to do this.Thank you. |
|
|
alaguganesh
Starting Member
1 Post |
Posted - 2009-07-20 : 03:02:40
|
| You can use PIVOT for the process matrix report it will change row into column ok...Please try that or you send the detail about your query i can write a Stored Procedures for in SQL Server 2000 or 2005Known is drop unknown is ocean... |
 |
|
|
|
|
|
Matrix Report design