group selection

[mwmark]

SAP crystal 14, sql DB.

I have a simple sales report that i want to see ONLY invoice details for invoices that have both sales classes on the same invoice. Not either /or

I am excluding all other sales classes in the select expert.
Group 1 is invoice, group 2 is class.
details are invoice number, class, selling_price

I have been away from this a while so I apologize if this is a simple fix that I am missing.
thanks

 

[pmax9999]

Use the following code in the Group Selection formula:

[Code Group_Selection]
DistinctCount({Table.Class}, {Table.Invoice}) = 2
[/Code]

Hope this helps

Cheers
Pete

 

[mwmark]

Thank you!

Worked like a charm.