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 |
|
jhoge123
Starting Member
8 Posts |
 Posted - 2007-04-01 : 19:01:34
|
| Hi,Is there a tutorial on how to do a matrix report with row & column tables? This is easy on by default in Crystal, but I can't figure out how to do it in RS.Thanks,John |
|
|
jhermiz
3564 Posts |
Posted - 2007-04-01 : 19:48:27
|
quote:
Originally posted by jhoge123
Hi,Is there a tutorial on how to do a matrix report with row & column tables? This is easy on by default in Crystal, but I can't figure out how to do it in RS.Thanks,John
Its very simple in RS.The best to learn is to practice.Try a query like so:SELECT SUM(MyCash) AS TheTotalSpent, Month(MyDateSpent) AS TheMonthFROM MyTable GROUP BY Month(MyDateSpent) ORDER BY TheTotalSpentThen in your report place the total field as a row field and the TheMonth field as a column header. Matrix reports are probably the simpliest reports in RS.You can click my signature link for more tips and tricks in reporting services.Good luck :)Programmers HowTo's -- [url]http://jhermiz.googlepages.com[/url] |
 |
|
|
jhoge123
Starting Member
8 Posts |
Posted - 2007-04-03 : 09:06:09
|
| Sorry, I mistyped my original quesiton. What I wanted to say is Is there a tutorial on how to do a matrix report with row & column totals? I can get as far as a matrix that will put data on the horizontal and vertical axes with a sum in the center. What I'm looking for is for each column and row to have a total.Thanks,John |
|
|
|
|
|
|
Matrix Report with Totals