Hi
I'm new to Crystal Reports and would be grateful of some assistance. I have a report which consists of one table. The report is a list of customers with transactions posted to their accounts the previous day. Each transaction is identified by a Trancode. My report has to detail all those customers who had  a combination of both a Trancode 61 & 6J. To clarify, I only want those customers who had both Trancodes. If they had one or the other they would not appear on the report.
Using the Select Expert I get this formula:
{AccTran.TransProcessDate} = DateTime (2014, 05, 02, 00, 00, 00) and
{AccTran.TransCode} in ["6J", "61"]
However when I Group this under the customer it produces a report for every customer who had either one of the Trancodes not both.
Thanks

George

Also note that the use of the "{AccTran.TransCode} in ["6J", "61"]" criteria in the record select will limit the returned values for the client ot only show those two records. If you want to see all activity for the client on that day remvoe that criteria from the record select.

Those were just examples as I don't know your data fields

Edited by DBlank - 08 May 2014 at 4:01am