Hello. I'm making a report using Crystal Reports 2008 and Peachtree database. Report should display customers who didn't place orders in a last 30 days. I already figured out how to link two tables in CR with left outer join. But I wasn't able to find how that linking can be used in formulas, such as selection formula. What am I trying to achieve is to get date of last placed order for current customer and use this information to determine if customer should be displayed or not. What is the right approach to solving this problem?

Edited by Romanzes - 11 Jan 2013 at 1:01am

Sastry, thank you very much, I'll try this.