Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to use group selection

Status
Not open for further replies.

nnaacc

Technical User
Mar 1, 2000
18
US
I have a report set up using record selection, and it can query for one customer at a time based on 2 parameter values: the customer name and the sales person. The customer could be a buyer or seller so my record selection has an OR statement:
(
({Orders.buyer}={?Cust} and
{Orders.buyRep}={?Rep})
or
({Orders.seller}={?Cust} and
{Orders.sellRep}={?Rep})
)

I want to set up the report so it can generate separate reports for several customers at once. I can't set up a simple selection:
{Orders.buyer} IN [Cust1,Cust2,Cust3...]
because a one record could have 2 customers from the list and therefore the report has to essentially read it twice, and place the record into two separate groups... ?

I think the way to do this is with Group Selection, but I don't know how to start.

THANKS in advance for any help!!
 
Use a UNION sql statement to append the same record
multiple times.

Cheers,
- Ido ixm7@psu.edu
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top