newbie question

[kisasama]

I'm really new with crystal reports, actually maybe a few days new, so if this sounds really rediculas pls don't be offended. I'm using crystal reports 10 with an ACUODBC cobol databases. I have a couple of questions that possibly someone may help me with.

I have a customer database with custID and a orders db with custid. now what I want to do is see how many customers have ordered once within the last 8 months or so. I created a blank report and added both db's and grouped it under the custID. Now the question is how do I iterate through through each group and show a number of total orders and just display that group.. I hope this doesn't sounds complicated. If anyone can help It will be much appreciated. And please Baby steps.

Regards.
Kisa

 

[lbass]

If you use an equal join on customer ID to join the two tables and then use a record selection formula of:

{table.date} in dateadd("m",-8, currentdate) to currentdate

...only those customers who have placed an order will be returned. After grouping on {table.customerID}, you can right click on your {Orders.OrderID} field and insert a summary (distinctcount) to display the number of orders per customer.

-LB