Home › Forums › Developers › General developer's discussion ›

Calculate new clients of the month

Submitted by Guest on Wed, 17/02/2021 - 14:05
in

Hi everyone,

With the MySQL table structure of OpenVPMS, I wonder what would be the accurate SQL queries for calculating the amount of new clients per month.

Thank you very much.

Regards,

Viet

‹ API Query Limit OTC Sales to Merchandise or NON S4(Prescription) Medications ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Calculate new clients of the month

Submitted by tanderson on Wed, 17/02/2021 - 14:12.

Take a look at reports/Reporting/Reports/Customer/A4/Customer Acquisition Report.jrxml in the OpenVPMS release distribution.
This is a JasperReport and includes the SQL to retrieve customers created between two dates.

Syndicate content