custom reports --

[raymond]

OK -- so we need to create some custom reports but I'm not exactly sure how to make custom "calculation" fields. At the moment, I need to create a custom Employee Charges Summary report except we need only labor items and the rows need to be broken out by Item Labor Type. How do we do this (the documentation does not show us how)?

//ray

[Support Team]

Re: custom reports --

For calc fields you select the DbCalc component from the toolbar, place it on the report layout and then select a data field to it. For example, you select the Charge total amount field and then it'll sum it. To include only labor Items you will need to filter the report to include only these and when it comes to grouping it is a matter of sorting the data by the field you want to group and then create a group inside the report designer based on it, this way it will group-break any time the item changes. This requirement is pretty stiff though. For what it work please find some related links that you may have explored already:


* Reports Designer User Guide
* Reports FAQ

Hope this helps.