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 |
|
siddadav
Starting Member
2 Posts |
 Posted - 2012-01-10 : 08:14:45
|
| Hi,I would be grateful for any help I could get with this one.I have a report that returns data for any given 4 week period, and I am finding it hard to get my Matrix report to create a Total for each week, All I can manage to do is create a Total for the whole 4 week period.my report shows month, week number and days, in the column, this is grouped by month and Week number.the Data that gets returned is staff information with 3 types of information returned for each staff member with is grouped by Staff.Regards |
|
|
siddadav
Starting Member
2 Posts |
Posted - 2012-01-10 : 10:53:27
|
quote:
Originally posted by siddadav
Hi,I would be grateful for any help I could get with this one.I have a report that returns data for any given 4 week period, and I am finding it hard to get my Matrix report to create a Total for each week, All I can manage to do is create a Total for the whole 4 week period.my report shows month, week number and days, in the column, this is grouped by month and Week number.the Data that gets returned is staff information with 3 types of information returned for each staff member with is grouped by Staff.Regards
I have resolved this now. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-10 : 10:55:10
|
| for benefit of other can you post how you managed to do it? did you add a new column group on days?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Matrix Grouping