Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Creating a Matrix table in SSRS Expand / Collapse
Author
Message
Posted Monday, August 5, 2013 6:04 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 3:08 AM
Points: 954, Visits: 878
Hi All

I need your help in creating a matrix table to display data as per attached image.

I have uploaded a sample data in excel and the sql script. Im not so good in SSRS

Thanks





It's better to fail while trying, rather than fail without trying!!!


  Post Attachments 
sampledata.xlsx (15 views, 316.13 KB)
stats.txt (7 views, 585 bytes)
Post #1480884
Posted Monday, August 5, 2013 10:15 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 18, 2014 1:00 PM
Points: 178, Visits: 215
Your data might spread into July, August etc. since "Queries resolved,Queries resolved in SLA, Queries resolved out of SLA, Queries resolved in SLA" fixed fields, I would recommend to keep these as columns. Month (or Month with Year) and other numbers can be rows (which can grow seamlessly in vertical direction).
If you wish to have same report format, then consider using Pivot queries in SQL for your reporting needs.
Post #1480993
Posted Tuesday, August 6, 2013 12:06 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 3:08 AM
Points: 954, Visits: 878
Thanks for your response

It's monthly report that will only show 2 months of data comparing previous and current month





It's better to fail while trying, rather than fail without trying!!!
Post #1481165
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse