multiple lines in detail for each record need to supress

[shummy1]

OK I am not sure how to word this one.
I am using crystal 8.5
I have a list of customers.
each customer number has many orders.
I need to creata a formula that will go through the orders and return a Y if there is an NSF charge on any of the transactions per order.
The problem is I do not want to see all of the transactions for the customer for each order.
I have tried a second detail section but it still repeats the order #s for each transaction

 

[lbass]

I'm assuming you want only one row per order, and that you are okay with multiple orders displayed per customer. Insert a group on {table.customer} and then on {table.orderno}. Then create a formula like the following to be placed in the detail section:

if {table.field} = "NSF Charge" then "Y"

Then right click on this formula and insert a summary (maximum) at the group level (order). If there is a "Y" in the group, the "Y" will show, or else it will be blank. You can drag the result to the group header (Order) and then suppress the detail section.

-LB

 

[shummy1]

That worked. Thank you