In version 1, Apsona had multi table reporting with visualizations like bar charts and matrices. Now, the application also has calculated fields in reports. The calculated fields are based on javascript.
Example: : $r['Final Selling Price']+$r['Shipping Price']-$r['Landed Cost Price']-$r['Shipping Cost']
To use the feature:
* Click the add column drop down in the report wizard and choose the field calculated value.
* Change the column name for the field to match the calculation. Example: Profit or totals and so on.
* In the calculation box enter the calculation. Syntax for the fields are : $r['fieldname']. The field name should be the exactly the same as chosen for the report.
* Choose the result type of the calculated field from the drop down, depending on the data type you want the calculated field to render.
* Click OK. Save and run the report and the report will have the calculated value.
Since the calculated fields are javascript based , users can now run complex reports with ease . Dependence on IT teams is a thing of the past, and quick, fancy reports can be run in minutes.
Try Apsona reporting and experience its power. Feedback will be welcomed.