New Customer Product marketing report
I have added a new customer marketing report to be used to export a set of clients for mail outs etc
http://www.openvpms.org/customisation/customer-product-marketing-report
This report differs from the original in that it searchs based on a given set of product sales rather than active customers etc, although it still filters for active customers and patients.
Re: New Customer Product marketing report
A couple of additional points when using these reports. Particularly when you believe the report will return a large amount of data.
These reports will fail with wierd errors unless:
You must have atleast 2-6 gigabytes of space on the drive that MYSQL uses to store its temporary data.
The database I tested with this was 1.3gb - the temporary table generated when I ran this report on data from the last year alone was close on 2.6gb....
You can see how if you dont have the space its going to fail.
Re: New Customer Product marketing report
As soon as I click "Run", I get errors (attached below - sorry I have NO idea what these mean, they might as well be in Swahili):
Failed to create report: Errors were encountered when compiling report expressions class file:
1. Cannot cast from Long to String
value = (java.lang.String)(((java.lang.Long)field_patient_num.getValue())); //$JR_EXPR_ID=25$
<---------------------------------------------------------------->
2. Cannot cast from Long to String
value = (java.lang.String)(((java.lang.Long)field_c_id.getValue())); //$JR_EXPR_ID=29$
<--------------------------------------------------------->
3. Cannot cast from Long to String
value = (java.lang.String)(((java.lang.Long)field_patient_num.getOldValue())); //$JR_EXPR_ID=25$
<------------------------------------------------------------------->
4. Cannot cast from Long to String
value = (java.lang.String)(((java.lang.Long)field_c_id.getOldValue())); //$JR_EXPR_ID=29$
<------------------------------------------------------------>
5. Cannot cast from Long to String
value = (java.lang.String)(((java.lang.Long)field_patient_num.getValue())); //$JR_EXPR_ID=25$
<---------------------------------------------------------------->
6. Cannot cast from Long to String
value = (java.lang.String)(((java.lang.Long)field_c_id.getValue())); //$JR_EXPR_ID=29$
<--------------------------------------------------------->
6 errors
Re: New Customer Product marketing report
Yeah I am reworking this report as it was taking 10minutes to run!!