Display first 60 days only 1

[buckslor]

Hi All

I'm trying to display all orders for the first 60 days only, for each customer. For example

Customer A started ordering in June 7th, 2010
Customer B started ordering in November 4th, 2010
Customer C started ordering in July 18th, 2011

How can I have crystal display only data while suppressing the rest of the orders since for

Customer A (June 7 - July 7, 2010)
Customer B (November 4 - December 4, 2010)
Customer C (July 18 - August 18, 2011)

Any help in the right direction would be greatly appreciated.

Regards

 

[pmax9999]

Hi buckslor

If you only want the report to include orders in the first 60 days, you could add the following to your record selection:

{OrderDate} <= {CustomerCommencementDate} + 60

Replace {OrderDate} and {CustomerCommencementDate} with the appropriate fields from your database.

If you need the report to include all orders, but only display those in the first 60 days, you could use conditional suppression to suppress those orders where:

{OrderDate} > {CustomerCommencementDate} + 60

Hope this helps.

Cheers
Pete.

 

[IanWaterman]

Assuming you do not have a customer commencement date just a first order date

Group by customer, eg CustomerID

In details go to section suppression and enter formula

OrderDate > Minimum(orderdate, customerID)-60

You can also do this in Group suppression but the result is the same.

This will suppress details of orders over that date for each customer. If you want to do summaries of data you will need to use Running Totals with a reverse evalation condition. When data is suppressed it is still there so if you use ordinary summaries they will be included in totals etc.

Ian

 

[buckslor]

{OrderDate} <= {CustomerCommencementDate} + 60

Worked out great. Thanks Pete.