Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 661
  • Last Modified:

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

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
AnnaJames77
Asked:
AnnaJames77
  • 3
1 Solution
 
rajvjaCommented:
Hi

You can do using Matrix tool on the report
0
 
rajvjaCommented:
And also this link for your reference.

http://msdn.microsoft.com/en-us/library/ms157334.aspx
0
 
AnnaJames77Author Commented:
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
 
rajvjaCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now