Solved

Read group values in SSRS 2008 R2

Posted on 2011-02-25
1
770 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

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.

Question has a verified solution.

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

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

733 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