Solved

SSRS Report using matrix

Posted on 2013-12-26
1
582 Views
Last Modified: 2014-01-13
I have table with following data when I build Matrix report using SSRS it displays Jan,Feb and July that is true. One of my users requested to show the months which does not have any data also. In Nutshell they want to show all months regardless of the data present for that particular account. How will do this in SSRS. ANy help is appreciated.

Accountid   Period  Yr    Amount
1000            Jan      2013    $200
1000           Feb      2013    $400
1000           July      2013    $700

Output should like this

Accountid      Jan      Feb      March      April      may      June  July Aug      Sep      Oct      Nov      Dec
1000                      200      400      0                 0        0         0        700        0      0      0      0      0
0
Comment
Question by:SURESH0518
1 Comment
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 39740352
Show us the T-SQL that serves as the DataSet source for this matrix.

Ultimately, it will need to be changed so that it is a {months table} LEFT JOIN {the rest of your T-SQL}, so that the data will contain all months, and the SSRS matrix will reflect it.

afaik what you are asking is not possible solely in SSRS.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
permissions for report in mssql reporting services 1 69
SSRS Problems 9 56
Textboxes line spacing 6 34
SSRS String Manipulation 6 40
Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now