Solved

PLS HELP--display ssrs report with jan to dec month tables

Posted on 2011-02-22
4
622 Views
Last Modified: 2012-05-11
The SSRS report  i need should have the header like JAN, to DEC.
The column is  the total of a given item in that particular month
say if  rows are

ITM  --   DATE   ----------QTY
PH001-- 01/jan/2010 --   5
PH001-- 07/jan/2010 --   10
PH001-- 01/feb/2010 --   5
PH009--21/jan/2010 ---50
PH009--21/mar/2010 ---50
PH009--21/feb/2010 ---50

Output shud be like
ITM   ----   JAN --FEB --MAR --APR-- MAY--........--DEC
PH001 --   15 ------5
PH009 ---  50-----50---50

PLS HELP
0
Comment
Question by:AnnaJames77
  • 3
4 Comments
 
LVL 11

Expert Comment

by:rajvja
ID: 34950746
Hi

You can do using Matrix tool on the report
0
 
LVL 11

Expert Comment

by:rajvja
ID: 34950752
And also this link for your reference.

http://msdn.microsoft.com/en-us/library/ms157334.aspx
0
 

Author Comment

by:AnnaJames77
ID: 34950756
i tried with matrix..it works..but i need the month name always to appear even if no items are there in that month
0
 
LVL 11

Accepted Solution

by:
rajvja earned 500 total points
ID: 34950794
Hi,

  I had a blind solution.
Create a table with all month names. Do a join this table with your query and bind that final query to your report.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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: …
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

707 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

14 Experts available now in Live!

Get 1:1 Help Now