Lapsed client report

Submitted by Guest on Tue, 26/07/2011 - 17:08

General User's Discussion

We would urgently like a report that shows us clients that have not been to see us for 12months, but have seen us within the last two years.

Is there such a report?

If not what funding would be required to make it happen?

Cheers

Dianne

Re: Lapsed client report

Submitted by tony on Wed, 27/07/2011 - 16:00.

Hi Di,

I haven't seen a report like this in the shared resurces. Think would be very useful and I have had some other OpenVPMS users approach me directly to write a similar report.

Heres a different idea .. lets get a good specification of what the report will do and then how about I build it and tell you how much time it took but rather than you and the others giving me the funds for this you contribute the same amount of funds to a current development project ?

I think those that contribute the funds to a project get the report and also have the rights to contribute to shared resources if they want to ...

Thoughts ?

Cheers

Tony

Re: Lapsed client report

Submitted by DiN (not verified) on Thu, 28/07/2011 - 14:53.

That sounds great Tony, we are more than happy to contribute towards it.

At the moment I'm trying to get data out about lapsed clients to send a mail out, so if it could be easliy formatted to enveolpe labels it would be super!

Cheers

Re: Lapsed client report

Submitted by tony on Mon, 01/08/2011 - 12:10.

Hi Di and everyone,

I have created a new report which can be used to export customer details for customers who's last transaction was in a specified period. This can be used to report on "lapsed" customers. You can find it here. (http://www.openvpms.org/customisation/customer-last-transaction-export-r...)

I have decided that I will contribute the report and hope anyone who uses it contributes something to one of the projects looking for funding. Of course , like everything in OpenVPMS, this is purely a honesty system. :-)

Cheers

Tony