Solved

Read group values in SSRS 2008 R2

Posted on 2011-02-25
1
767 Views
Last Modified: 2012-05-11
I have SP which returns Companyname, years, sales columns

Example :
CompanyA 2005, 1000
CompanyA 2006 100
CompanyA 2007 500

Like wise for 10 different companies and 4 different years.

I am using matrix in SSRS to show the data.

I need to show data like this

Company Name  2006 2007 2008 [sales percentage increase(06-07)] [sales percentage increase(07-08)]

So i need to get value from the previous column group and do the calculations.

Please help?

A

0
Comment
Question by:RNGAdmin
1 Comment
 
LVL 17

Accepted Solution

by:
MIKE earned 500 total points
ID: 34987940
have you tried placing these in the ROW HEADER Cells, then copy/pasting logic from previous cell into next...?

In other words don't use the expandable / aggregate cells of the matrix but instead ADD Row Header cells and use those.....
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

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
A short film showing how OnPage and Connectwise integration works.

948 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

20 Experts available now in Live!

Get 1:1 Help Now