Hello,

I'm working on a report that shows the sales order lines for a specific month if the sales team contacted the specific account within a certain time period.

The report utilizes only two tables:

Table 1

-AcctNbr
-ContactDate
-SalesRep

Table 2

Contains sales order data fields

The report is grouped by the acctnbr field from table 1. I am getting repeating sales line details because in table 1 there are multiples AcctNbr enties within the same date range I'm using in the selection criteria, I realize it.

Is there a way to refine the selection criteria to display records only once even though there are multiple contacts to the same AcctNbe within the date range I provided?

Any help would be greatly appreciated, I'm completely lost here.

Hi

you could write a crystal command object using select distinct as your source

Edited by DBlank - 07 Aug 2012 at 4:41am

Best bet would be to use Sastry's sugggestion.

Edited by DBlank - 07 Aug 2012 at 6:06am