Solved

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

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS - Suppress row when blank from 2nd dataset 2 40
Complex SQL script 1 30
SSRS Access Remotely 5 54
Delete Trigger in SQL Server2008R2 5 20
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

943 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

9 Experts available now in Live!

Get 1:1 Help Now