This topic is locked

Sum/Avg on Reports in PHPR 5

1/27/2009 10:33:22 PM
PHPRunner General questions
U
unimatrix author

We had a report built under PHPR 4.2 that would show sales by month and give the total for that month (sum), and an average per order.
In PHPR 5, those blocks are grayed out. Now we did make a structural change to the program and developed a new database schema. In phpr 4.2, the field type for total was varchar. In the new system it is a MySQL decmail field. It seems like in PHPR 5, that the reports does not like to allow sum/aver/min/max calculations unless the field type is INT in MySQL.

J
Jane 1/28/2009

Hi,
aggregate functions on the reports works for int and double fields.

Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.