Skip to Content
0
Former Member
Nov 22, 2011 at 09:25 PM

Displaying all group records in a group footer

27 Views

I'm told this is possible. I would appreciate it if someone here could verify this for me, and show me how it would work.

Here is my report structure:

GH1 (State)

GH2 (Customer information for customer from that state)

Details (Sales Reps associated with a customer)

GF2

GF1

I want to display all sales reps associated with a state. So the report would be formatted like this instead (for example):

Alabama

[Customers]

Bob Jones

Jane Smith

[Sales Reps for Alabama customers]

John Doe

Sally Davis

Todd Jackson

Arizona

[Customers]

Dave Johnson

Julie Brown

[Sales Reps for Arizona customers]

Susie Thompson

Jack Miller

etc...

My data comes from a stored procedure, and I put the customers in a group header because they would be duplicated otherwise (since a customer can be associated with multiple sales reps). Is it possible, without modifying the stored procedure or query, and without using a subreport, to list all sales reps associated with a state?

Thank you.