Post reply

Creating a Matrix table in SSRS

  • August 5, 2013 at 6:04 am

    #275855

    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!!!

  • August 5, 2013 at 10:15 am

    #1638660

    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[/url] for your reporting needs.

    Thanks,
    Naveen.
    Every thought is a cause and every condition an effect

  • August 6, 2013 at 12:06 am

    #1638793

    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!!!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply