One of the Report Renderers that ships with the reporting module provides the capability of rendering the report into a custom created Excel template. This is often useful for presenting reports in a prescribed format to a reporting agency and allows graphs, formulas, and other calculations to add richness to your report.
...
| No Format |
|---|
repeatingSections= sheet:[number} where the number is the order of the worksheet on the excel template. Do not use the name of the worksheet. (ie. sheet:1) row:[number] where the number is the starting row on the excel worksheet where the data should be added dataset:[dataSetName] where the dataSetName is the name used in the report |
You can handle "row-per-xyz", "row-per-encounter", etc. datasets that have a variable number of rows by setting some properties on the ReportDesign. Add a property called "repeatingSections", where each "section" you want to repeat is separated by a "pipe" and contains a bunch of comma-separated attributes like this:
| No Format |
|---|
repeatingSections=sheet:1,row:12,dataset:someDataSet|sheet:2,row:3,dataset:nonNumerics |
This tells the renderer to repeat every row in the dataset that the report knows as "allPatients", using rows 6-8 in sheet #1 as a template (you will end up with lots of rows)
| No Format |
|---|
sheet:1,row:6-8,dataset:allPatients |
...