group by....

Hi,
I am new to RS... here is problem.
Its a simple report which shows the detail of top sale performers
Nationally. We have 4 regions... east, west, north and south. I the
report detail I print out a report card... showing each performer's
detail... somthing along the lines
Region Rep $<sales> $<commission> .....
I want to have a snapshot at the top which will list the 4 regions and
numbers of reps from each region that made the cut...
National Summary:
East 4
West 5
North 16
Sount 0
I dont want to query the DB again as I already have that info.
Basically I need to use a group by <region> in reporting serices with
counting the reps? How do I accomplish this?I see that you could use one of three ways. You could created a graph
grouping by region and counting the reps or just insert another table above
your current table with just the region grouping and counting the reps. The
last way is a bit more complicated and ivolves using the case statement and
you could put it in your header. Example:
Region 1 Region 2 Region 3 Region 4
5 3 7 1
if you are interested in the case statement then let me know and I will help
you with that.
"zomer" <noneee@.gmail.com> wrote in message
news:1165257406.682491.148580@.n67g2000cwd.googlegroups.com...
> Hi,
> I am new to RS... here is problem.
> Its a simple report which shows the detail of top sale performers
> Nationally. We have 4 regions... east, west, north and south. I the
> report detail I print out a report card... showing each performer's
> detail... somthing along the lines
> Region Rep $<sales> $<commission> .....
> I want to have a snapshot at the top which will list the 4 regions and
> numbers of reps from each region that made the cut...
> National Summary:
> East 4
> West 5
> North 16
> Sount 0
> I dont want to query the DB again as I already have that info.
> Basically I need to use a group by <region> in reporting serices with
> counting the reps? How do I accomplish this?
>