...
for (var index=0; index < ENCOUNTERS.Count; index++) {
var encounter = ENCOUNTERS.GetEncounter(index);
var encounterName = encounter.#IntervalName.displayValue.toString();
if (encounterName =="Baseline") var BaselineIndex=index;
else if (encounterName=="Month 1") var Month1Index=index;
else if (encounterName=="Month 2") var Month2Index=index;
}
...
// Create the desired layout
Variable | Baseline | Month 1 | Month 2 |
|---|---|---|---|
Encounter Date | <%=BaselineEncounter.#EncounterDate%> | <%=Month1Encounter.#EncounterDate%> | <%=Month2Encounter.#EncounterDate%> |
Variable 1 | <%=BaselineEncounter.#Variable1%> | <%=Month1Encounter.#Variable1%> | <%=Month2Encounter.#Variable1%> |
Variable 2 | <%=BaselineEncounter.#Variable2%> | <%=Month1Encounter.#Variable2%> | <%=Month2Encounter.#Variable2%> |
...
An example of the output from the Report Template above:
Variable | Baseline | Month 1 | Month 2 |
|---|---|---|---|
Encounter Date | 10/1/2011 | 11/5/2011 | 12/2/2011 |
Variable 1 | 128 | 123 | 118 |
Variable 2 | 75 | 60 | 62 |
...