New Business Report

building reports crystal reports
1

I am trying to create a “new business report”. I want to show:

a, the first transaction for a customers who have never booked before if the new record falls in the date range specified
and
b, the first transaction for a “lost” customer. A lost customer is when a customer booked an transaction, and they haven’t booked one for more than 12 months previous to that.

I hope that makes sense

Can I do this in Crystal or will I need a view to select the data first.

Thanks

philt (BOB member since 2008-02-29)

2

I use CR2008 rather than CRXI but as far as I am aware, CR cannot do NULL joins.

You want to link a table to itself and your selection criteria is;

Give me all the records in the left hand table where there is no result in the right hand table. CR won’t do that, so yes, you will need to create it as a view in your data source first and then access the view in CR.

Obiron

obiron (BOB member since 2008-01-10)