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 |
|
darkdusky
Aged Yak Warrior
591 Posts |
 Posted - 2008-11-04 : 06:46:23
|
| Hi,I have a matrix with hour as column group (9am to 5pm). Each hour has another 8 different column values.Day is seperate row (Monday to Friday). I added a subtotal to the hour column which works great. The subtotal has 8 columns giving me averages for each of the 8 fields.I need to show a similar subtotal for the morning (9am to 1pm) and afternoon (1pm to 5pm).This website does something similar:http://sqlskills.com/blogs/liz/post/Reporting-Services-Getting-the-Matrix-to-Display-Two-Subtotals-for-the-Same-Group-.aspxIs it possible to use my Day row as the "dummy group" used in the example webpage.I haven't used Inscope before. Do I need to do this individually for each of the 8 fields displayed in each hour's column? |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2008-11-05 : 12:33:29
|
| yuk! Would it be easier to use 2 matrix controls that are ordered similarly but grouped by the hours you need?Hey, it compiles. |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2008-11-06 : 13:07:25
|
| Why not just add another regular grouping? In your result set, create a column that will identify whether the hour is morning or afternoon, and then just use that as the top level grouping?---------------------------EmeraldCityDomains.com |
|
|
|
|
|
|
Subtotals