*** Please note code below is no longer needed.  Use the point-and-click method using the Repeater control Image Added  ***

Data Across Encounters

Displaying a table with one row per encounter

Code that can be entered into a Report Template:

...

Output.Write("<table border='1' cellspacing='0' cellpadding='5'>");
Output.Write("<tr><th>Encounter Date</th> <th>Encounter Name</th></th> <th>Variable 1</th> <th>Variable 2</th> </tr>");

// Loop through the encounters and output the encounter date and encounter name 
   // Each time through will create a row in the table with the next encounter  

for (var index=0; index < ENCOUNTERS.Count; index++) {
     var encounter = ENCOUNTERS.GetEncounter(index);
         var encounterDate = encounter.#EncounterDate.displayValue.toString();
         var encounterName = encounter.#IntervalName.displayValue.toString();
         var variable1value = encounter.#Variable1.value.value;
         var variable2value = encounter.#Variable2.value.value;

   Output.Write("<tr><td>" + encounterDate + "</td>");
   Output.Write("<td>" + encounterName + "</td>");
   Output.Write("<td>" + variable1value + "</td>");
   Output.Write("<td>" + variable2value + "</td></tr>");

}

Output.Write("</table>");

%>

An example of the output from the Report Template code above:

Displaying a table with one row per encounter with the encounters sorted in descending order

Code that can be entered into a Report Template:

<%

Output.Write("<table border='1' cellspacing='0' cellpadding='5'>");
Output.Write("<tr><th>Encounter Date</th> <th>Encounter Name</th> <th>Variable 1</th> <th>Variable 2</th> </tr>");

var encountersSorted = ENCOUNTERS.Sort(#EncounterDate.ID, false);

for (var index=0; index < encountersSorted.Count; index++) {

     var encounter = encountersSorted.GetEncounter(index);
         var encounterDate = encounter.#EncounterDate.displayValue.toString();
         var encounterName = encounter.#IntervalName.displayValue.toString();
         var variable1value = encounter.#Variable1.value.value;
         var variable2value = encounter.#Variable2.value.value;

   Output.Write("<tr><td>" + encounterDate + "</td>");
   Output.Write("<td>" + encounterName + "</td>");
   Output.Write("<td>" + variable1value + "</td>");
   Output.Write("<td>" + variable2value + "</td></tr>");

}

Output.Write("</table>");

%>

An example of the output from the Report Template code above:

Outputting the data from latest encounter which meets a condition

Code that can be entered into a Report Template:

<%

Output.Write("<table border='1' cellspacing='0' cellpadding='5'>");
Output.Write("<tr><th>Encounter Date</th> <th>Encounter Name</th> <th>Variable 1</th> <th>Variable 2</th> </tr>");

var encountersSorted = ENCOUNTERS.Sort(#EncounterDate.ID, false);

for (var index=0; index < encountersSorted.Count; index++) {

     var encounter = encountersSorted.GetEncounter(index);
         var encounterDate = encounter.#EncounterDate.displayValue.toString();
         var encounterName = encounter.#IntervalName.displayValue.toString();
         var variable1value = encounter.#Variable1.value.value;
         var variable2value = encounter.#Variable2.value.value;

 if (variable1value >= 150) }

   Output.Write("<tr><td>" + encounterDate + "</td>");
   Output.Write("<td>" + encounterName + "</td>");
   Output.Write("<td>" + variable1value + "</td>");
   Output.Write("<td>" + variable2value + "</td></tr>");

  break;

 }

}

Output.Write("</table>");

%>

An example of the output from the Report Template code above:

Displaying data in a custom layout from fixed encounters

Code that can be entered into a Report Template:

...

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

%>

An example of the output from the Report Template above: