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>