In the last post, we created a conditional ad hoc report. If you have not read that post yet, please read it here. The newly created report appears in the reporting dashboard for users to invoke it. Users with appropriate permissions can edit the report, copy and create a similar report,schedule the report to be delivered via email and of course delete the report.
Today, we will look at additional capabilities of ad hoc reporting. So, you edit this report and navigate to the wizard again. On the main page of the ad hoc reporting wizard, you have a button for configuring display details.
Clicking this button you can configure display details of the report - provide your own field names, specify formatting, apply sums and averages (see below). In a later version, we will let you input your own formula and create calculated fields as well.
Additionally, you could also choose fonts, colors and attach logos to the report as well - see screen below.
Finally, you have the ability to further improve your report by sorting on as many fields as needed, group by multiple fields and total numeric fields. Flow codes within the system identify +ve and -ve transactions and thus you can be rest assured that your sub and grand totals are accurate. See example of sorting and grouping below.
Thus we have created an ad hoc report that reports on current day transactions, sorted by account number and transaction code, grouped and totaled by flow code and with summations on amount. In the next post we will run the report, export it and see how to schedule reports using the ad hoc reporting tool.
Thank you for reading so far, do let me know should you have any questions or comments - especially if you have recommendations on how to improve our ad hoc reporting tool.