Fields

The following fields are available for use in reports.

If you are using an old report template, open the report in notepad or other text editor and update the <columns> as per the specification below to make all of the available fields available.


Accepted Entries (From v9250217)

  <Columns>
    <DataColumn Name="MeetName" />
        <DataColumn Name="SwimmerClub" />
        <DataColumn Name="SwimmerName" />
        <DataColumn Name="SwimmerYear" />
        <DataColumn Name="EventNo" />
        <DataColumn Name="EventName" />
        <DataColumn Name="Competitor" />
        <DataColumn Name="SwimmerTime" />
        <DataColumn Name="Session" />
        <DataColumn Name="EventTime" />
        <DataColumn Name="Generated" />
        <DataColumn Name="SwimmerDOB" />
        <DataColumn Name="SwimmerAge" />
        <DataColumn Name="Disability" />
        <DataColumn Name="ISDisability" />
	<DataColumn Name="SwimmerTimeSort" />
	<DataColumn Name="EventNoShort" />
	<DataColumn Name="NoTime" />
	<DataColumn Name="SessionTime" />
  </Columns>

Heat / Start Lists

  <Columns>
        <DataColumn Name="MeetName" />
        <DataColumn Name="Session" />
        <DataColumn Name="SessionNo" />
        <DataColumn Name="EventNo" />
        <DataColumn Name="EventName" />
        <DataColumn Name="HeatNo" />
        <DataColumn Name="HeatNew" />
        <DataColumn Name="LaneNo" />
        <DataColumn Name="CompetitorNo" />
        <DataColumn Name="SwimmerName" />
        <DataColumn Name="Age" />
        <DataColumn Name="Disability" />
        <DataColumn Name="Club" />
        <DataColumn Name="Time" />
        <DataColumn Name="Swimmer1" />
        <DataColumn Name="Swimmer2" />
        <DataColumn Name="Swimmer3" />
        <DataColumn Name="Swimmer4" />
        <DataColumn Name="Swimmer5" />
        <DataColumn Name="Swimmer6" />
        <DataColumn Name="IsDisability" />
        <DataColumn Name="DisabilityCodes" />
      </Columns>

Meet Programme (From v9250223)

  <Columns>
    <DataColumn Name="MeetName" />
        <DataColumn Name="EventName" />
        <DataColumn Name="CompetitorNo" />
        <DataColumn Name="SwimmerName" />
        <DataColumn Name="Age" Type="Integer" />
        <DataColumn Name="Club" />
        <DataColumn Name="Time" />
        <DataColumn Name="Dots" />
        <DataColumn Name="Session" />
        <DataColumn Name="Disability" />
        <DataColumn Name="Gender" />
        <DataColumn Name="SSEventCode" />
        <DataColumn Name="QTCode" />
        <DataColumn Name="QTTime" />
        <DataColumn Name="SwimmerFirstName" />
        <DataColumn Name="SwimmerSurname" />
        <DataColumn Name="SwimmerDOB" />
        <DataColumn Name="SwimmerSE" />
        <DataColumn Name="SwimmerGender" />
        <DataColumn Name="Type" />
        <DataColumn Name="TimeSort" />
        <DataColumn Name="NoTime" />
        <DataColumn Name="EventNo" />
        <DataColumn Name="FinalOf" />
        <DataColumn Name="SessionDate" />
        <DataColumn Name="SessionTime" />
        <DataColumn Name="SessionAMPM" />
  </Columns>

The following calculated fields are also available in the Meet Programme Report
AgeGroup - Display Age Groups and ability to sort as 8/Under | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17/Over
AgeGroup-JN - Display Age Groups and ability to sort as Junior | Senior
AgeGroup-REG - Display Age Groups and ability to sort as 11/12 | 13 | 14 | 15 | 16 | 17/Over

Note: Some fields are only available if the 'Competing Swimmer' Report in Sport Systems has been run , otherwise the fields will be blank.

Heat Sheet Relays

  <Columns>
    <DataColumn Name="MeetName" />
    <DataColumn Name="Session" />
    <DataColumn Name="SessionNo" />
    <DataColumn Name="EventName" />
    <DataColumn Name="HeatNo" />
    <DataColumn Name="LaneNo" />
    <DataColumn Name="ClubName" />
    <DataColumn Name="TeamName" />
    <DataColumn Name="TeamTime" />
    <DataColumn Name="SwimmerName" />
  </Columns>