How to compare prior month active customers with present

[tcbc]

Our system does not log span dates but rather uses on date field and when customer becomes in active we change status field and the date field . How would I use that date field to show what was active last month versus present info to get percentage diff.

 

[IdoMillet]

Please don't post the same question multiple times.

One option is to follow the logic of what's active or inactive based on transaction history of each customer.

A simpler approach is to take snapshots of the data at the end of each month and append the records to a new table. If you wish to do this based on data in a Crystal report, there's at least one Crystal Report Manager (among those listed at:

http://www.kenhamady.com/bookmarks.html)

that can automate that process for you.

hth,
- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com