Last post Jun 21, 2011 11:53 AM by ssanp
Aug 10, 2009 03:11 AM|Nick Asiimwe|LINK
hi all, i have a aproblem designing my sql serever reporting services matrix report, i have a table with following fields:
for a particualar date, i want to show the total count of records for a particualr Category
For example, for date "8/10/2009", i want to show the following
So far i have only managed to get daily totals for only unique categories( Category 1, Category 2, more....) but i would prefer totals further grouped by malaria, off-duties & referred) for a particualr date. Please help.
I basically want some thing that looks like this.
Aug 10, 2009 05:52 AM|arunkumarsp|LINK
kindly post some sample data to test your requirement
kindly go through the below link to get best and quick answer in forum
Aug 10, 2009 10:03 AM|Nick Asiimwe|LINK
with th above data, i would like my matrix report to appear as below
as you can see, if the problem field has any other value that is not malaria, then i dont care about it.
May 12, 2011 10:21 AM|ssanp|LINK
did you figure this out, i am trying to do something similar.
May 26, 2011 05:52 AM|Nishantg|LINK
I think you need to work on query side and then it should be simple on Report side. Following is the query I used to design the Report.
(Select COUNT(Problem) From Sample P Where P.Category = M.Category And P.Date = M.Date And Problem = 'Malaria') as Maleria,
(Select COUNT(OffDuty) From Sample O Where O.Category = M.Category And O.Date = M.Date And OffDuty = 'True') as OffDuty,
(Select COUNT(Referred) From Sample T Where T.Category = M.Category And T.Date = M.Date And Referred = 'True') as Refered
from Sample M
Group By M.Date,M.Category
Design you Report as following
1. Date should be Row Group
2. Category should be Column Group
3. Rest columns are detail value
I hope this will help you.
Jun 21, 2011 11:52 AM|ssanp|LINK
actually it is pretty simple on report side, just got to group it on the ssrs side.
Jun 21, 2011 11:53 AM|ssanp|LINK
thanks for your reply though, would keep ur solution in mind for future, thanks.