Solved

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

Posted on 2011-02-22
4
635 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

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 Copy Database Wizard 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.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

839 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