October 28, 2008 at 11:51 am
I know how to do this in 2008, but can't figure out how to do this in 2005! In 2008 I use the wonderful Tablix, but I think I cannot do this in 2005. Can anyone help?
I have 4 simple fields in my query:
Country (i.e. "Australia")
Salesperson (i.e. "Jones, William")
Date (i.e. 2008-10-01)
TotalSales (i.e. $45,700)
my report needs to summarize each Country, showing sales by half-year for each salesperson. BUT, I also need to show a salesperson summary at the end of each Country. So, my report needs to look like this:
Australia First Half 2008: Jones, William $ 45,700
Smith, Mary $ 50,800
Taylor, Richard $110,500
Total: $207,000
Second Half 2008: Jones, William $100,000
Reed, Jill $ 15,900
Taylor, Richard $85,300
Total: $201,200
Total 2008 by Salesperson:
Jones, William $145,700
Reed, Jill $ 15,900
Smith, Mary $ 50,800
Taylor, Richard $195,800
Total: $408,200
Australia First Half 2008: Jones, William $ 50,200
Smith, Mary $ 50,800
...etc.
So far, I can get everything except for the grouping of "Total 2008 by Salesperson". I can do this in SSRS 2008 because in a Tablix you can add a group "outside" group, but I can't find a way to do this in 2005. Does anyone know if this is possible? I've attached the results from 2008 to show you what I'm trying to do...
Thanks in advance!
October 28, 2008 at 11:56 am
I can't think of an easy way (like SSRS 2008 Tablix)
because the SSRS 2005 really gives you only horizontal grouping (say Country, Salesperson, Date)
I am curious to know a solution too
October 28, 2008 at 12:38 pm
Thanks Jerry, I was afraid of that. I really need to create this report for my client, though. Is it possible to upgrade SSRS only to 2008 and leave the rest of my database as 2005?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply