I recently received a requirement to produce XLS output for one of the custom reports at a client. This report provides the basic information about the payments made, but if there is a payment, the report should include the history of the past 9 days along with the totals (by payment date). Also, a separate report (burst) needs to be created and distributed to the supplier.
Initially I had difficulty in designing the report, but realized it was actually easy after a bit of research and trial and error. I want to share my experience, tips and tricks in designing simple XLS templates and help techies who are curious to know how easy it is.