If you want to show multiple rows on the final excel spreadsheet, define the location on the template along with dataSetName in the Design Properties text area. In the attached example, the following format is used:
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. What you need to do is to 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:
sheet:1,row:6-8,dataset:allPatients - 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)
sheet:2,column:4:dataset:malePatients - this tells the renderer to repeat every row in the dataset that the report knows as "malePatients", using column #4 in sheet #2 as a template (you will end up with lots of columns)
sheet:3,dataset:femalePatients - this tells the renderer to repeat every row in the dataset that the report knows as "femalePatients" using sheet #3 as a template (you will end up with lots of sheets).
If you have a dataset added to the report with the "key" of "rowPerReceptionEncounter", and with dataset columns named "receiptNum" and "paymentType". the Excel document starts outputting these on line 5 of the first workbook of your Excel document in columns 2 and 3 of these rows. Do the following 2 things:
- Add the following "property" to your ReportDesign: repeatingSections=sheet:1,row:5,dataset:rowPerReceptionEncounter
- on your actual Excel template, on sheet 1:
- In row 5, column 2, put the value: #receiptNum#
- In row 5, column 3, put the value: #paymentType#
|  Image Removed
| |
|  Image Added |