I'm new to writing reports, and I'm looking for some advice on where the responsibility lay for generating calculated fields. Whether it should be done by the app/database server pre-import or by ZOHO once the raw data has been imported.

Let's look at a simple example. I have two tables, Customers and Orders, each order is assigned a customer, each customer may have many orders.

Say I want to know how many orders each customer has placed, or that customers total spend, or their average spend per order.

Should I be calculating this data on my server before passing the data into ZOHO? Or should I be using ZOHO to calculate things such as this?

Thanks, I appreciate your advice.

Robert