Page Comparison

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  

In this 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  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:

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)

sheet:

1,

row:6-8,dataset:allPatients

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:

2,column:4:dataset:

malePatients

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). :

sheet:3,dataset:femalePatients

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:

1. Add the following "property" to your ReportDesign:  repeatingSections=sheet:1,row:5,dataset:rowPerReceptionEncounter
2. on your actual On sheet 1 of the Excel template, on sheet 1:
   1.  In row 5, column 2, put the value:  #receiptNum#
   2.  In row 5, column 3, put the value:  #paymentType#