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!!
(
({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!!