I have a sales order report that has several fields.  The primary field is the sales order # and there are records like item name, qnty, amount, status, sales person.....  One of the tables is a custom fields table that shows the status.  That same field that the status is in there is another record associated with the sales order.  Because of this my sales orders are repeating when there are two records in the cf_field associated with the sales order.  How do I limit the occurrance of that filed?  I only need the status field, but sometimes the order has no status field so I would need an isnull, and sometimes it only has the other record "rep group" associated with it.  I don't care if it shows the rep group or not, but I need it to show the status when there is one.  If I use a select formula to eliminate the rep group records some sales orders won't show up that don't have a status and do have a rep group.  Help Please!

I'm grouping the report by date"daily" and my data is in the detail section because a single sales order can have multiple items and I need the items listed.  I have something like this;