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.