<?xml version="1.0" encoding="utf-8"?>
<Templates xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://gpsgate.com/xml/">
  <Template>
    <Object>
      <TemplateGuid>124af78a-dbf8-4da2-9b47-a93faf7dbd42</TemplateGuid>
      <TemplateVersion>2</TemplateVersion>
      <ObjectType>GpsGate.Reporting.v3.QueryWriter</ObjectType>
      <ObjectData>
        <Query>
          <Name>DistanceAndTemp</Name>
          <QueryText>SELECT data_time_stamp_start AS 'SamplingStart', data_time_stamp_end AS 'SamplingEnd', int_01 AS 'UserID', txt_01 AS 'StartAddress', txt_02 AS 'StopAddress', dbl_01 AS 'DistanceGps', dbl_02 AS 'DistanceOdo', dbl_03 AS 'MaxSpeed', dbl_04 AS 'AvgSpeed', dbl_05 AS 'Fuel', dbl_06 AS 'AvgTemp', dbl_07 AS 'MaxTemp', dbl_08 AS 'MinTemp', txt_03 AS 'FatPointState' FROM reportv3_data_store LEFT JOIN reportv3_data_store_ext01 ON reportv3_data_store.report_data_store_id = reportv3_data_store_ext01.report_data_store_id WHERE report_data_provider_id = 33 AND application_id = [ApplicationID] AND data_time_stamp_start BETWEEN [PeriodStart] AND [PeriodEnd] AND data_time_stamp_end BETWEEN [PeriodStart] AND DATE_ADD([PeriodEnd], INTERVAL 1 DAY) AND (true_break = 1 OR (true_break = 0 AND data_time_stamp_start != data_time_stamp_end))</QueryText>
          <QueryTextAlt1>SELECT data_time_stamp_start AS 'SamplingStart', data_time_stamp_end AS 'SamplingEnd', int_01 AS 'UserID', txt_01 AS 'StartAddress', txt_02 AS 'StopAddress', dbl_01 AS 'DistanceGps', dbl_02 AS 'DistanceOdo', dbl_03 AS 'MaxSpeed', dbl_04 AS 'AvgSpeed', dbl_05 AS 'Fuel', dbl_06 AS 'AvgTemp', dbl_07 AS 'MaxTemp', dbl_08 AS 'MinTemp', txt_03 AS 'FatPointState' FROM reportv3_data_store LEFT JOIN reportv3_data_store_ext01 ON reportv3_data_store.report_data_store_id = reportv3_data_store_ext01.report_data_store_id WHERE report_data_provider_id = 33 AND application_id = [ApplicationID] AND data_time_stamp_start BETWEEN [PeriodStart] AND [PeriodEnd] AND data_time_stamp_end BETWEEN [PeriodStart] AND DATEADD(DAY, 1, [PeriodEnd]) AND (true_break = 1 OR (true_break = 0 AND data_time_stamp_start != data_time_stamp_end))</QueryTextAlt1>
          <IsInternal>False</IsInternal>
          <Type>GpsGate.Reporting.v3.ProviderQuery</Type>
          <Parameters>
            <Parameter>
              <type_name>GpsGate.Reporting.v3.QueryReportSqlParameter</type_name>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <param_name>ApplicationID</param_name>
              <multi>False</multi>
              <value_field>ApplicationID</value_field>
              <label_field>Name</label_field>
              <user_def_value>Applications</user_def_value>
              <data_type>System.Int32</data_type>
              <default_value></default_value>
            </Parameter>
            <Parameter>
              <type_name>GpsGate.Reporting.v3.PeriodReportSqlParameter</type_name>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <param_name>Period</param_name>
              <multi>False</multi>
              <data_type>System.DateTime</data_type>
              <default_value>-1</default_value>
            </Parameter>
          </Parameters>
        </Query>
      </ObjectData>
    </Object>
    <Object ReadOnly="True">
      <TemplateGuid>9f008cfd-6a27-4361-9b78-868ea9543b9a</TemplateGuid>
      <TemplateVersion>22</TemplateVersion>
      <ObjectType>GpsGate.Reporting.v3.GateMessageReportDataProvider</ObjectType>
      <ObjectData>
        <ReportDataProvider>
          <Name>DistanceAndTemp</Name>
          <Description></Description>
          <Type>GpsGate.Reporting.v3.GateMessageReportDataProvider</Type>
          <Resolutions>
            <Resolution>
              <type_name>GpsGate.Reporting.v3.Provider.FatpointResolution</type_name>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <res_cust_data></res_cust_data>
            </Resolution>
          </Resolutions>
          <Columns>
            <Column>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <type_name>GpsGate.Reporting.v3.Provider.MinColumn</type_name>
              <col_name>SamplingStart</col_name>
              <col_description></col_description>
              <col_data_field>UTC</col_data_field>
              <col_data_field_type>System.DateTime</col_data_field_type>
              <col_data_store_slot>data_time_stamp_start</col_data_store_slot>
              <col_data_store_table>reportv3_data_store</col_data_store_table>
            </Column>
            <Column>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <type_name>GpsGate.Reporting.v3.Provider.MaxColumn</type_name>
              <col_name>SamplingEnd</col_name>
              <col_description></col_description>
              <col_data_field>UTC</col_data_field>
              <col_data_field_type>System.DateTime</col_data_field_type>
              <col_data_store_slot>data_time_stamp_end</col_data_store_slot>
              <col_data_store_table>reportv3_data_store</col_data_store_table>
            </Column>
            <Column>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <type_name>GpsGate.Reporting.v3.Provider.ValueColumn</type_name>
              <col_name>UserID</col_name>
              <col_description></col_description>
              <col_custom_data>Last</col_custom_data>
              <col_data_field>UserID</col_data_field>
              <col_data_field_type>System.Int32</col_data_field_type>
              <col_data_store_slot>int_01</col_data_store_slot>
              <col_data_store_table>reportv3_data_store</col_data_store_table>
            </Column>
            <Column>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <type_name>GpsGate.Reporting.v3.Provider.GeocoderColumn</type_name>
              <col_name>StartAddress</col_name>
              <col_description></col_description>
              <col_custom_data>Start</col_custom_data>
              <col_data_field>Address</col_data_field>
              <col_data_field_type>Franson.Geo.Location</col_data_field_type>
              <col_data_store_slot>txt_01</col_data_store_slot>
              <col_data_store_table>reportv3_data_store</col_data_store_table>
            </Column>
            <Column>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <type_name>GpsGate.Reporting.v3.Provider.GeocoderColumn</type_name>
              <col_name>StopAddress</col_name>
              <col_description></col_description>
              <col_custom_data>Stop</col_custom_data>
              <col_data_field>Address</col_data_field>
              <col_data_field_type>Franson.Geo.Location</col_data_field_type>
              <col_data_store_slot>txt_02</col_data_store_slot>
              <col_data_store_table>reportv3_data_store</col_data_store_table>
            </Column>
            <Column>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <type_name>GpsGate.Reporting.v3.Provider.GpsDistanceColumn</type_name>
              <col_name>DistanceGps</col_name>
              <col_description></col_description>
              <col_custom_data></col_custom_data>
              <col_data_field>TrackPoint</col_data_field>
              <col_data_field_type>Franson.Geo.TrackPoint</col_data_field_type>
              <col_data_store_slot>dbl_01</col_data_store_slot>
              <col_data_store_table>reportv3_data_store</col_data_store_table>
            </Column>
            <Column>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <type_name>GpsGate.Reporting.v3.Provider.OdometerColumn</type_name>
              <col_name>DistanceOdo</col_name>
              <col_description></col_description>
              <col_custom_data></col_custom_data>
              <col_data_field>OdometerAcc</col_data_field>
              <col_data_field_type>System.Double</col_data_field_type>
              <col_data_store_slot>dbl_02</col_data_store_slot>
              <col_data_store_table>reportv3_data_store</col_data_store_table>
            </Column>
            <Column>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <type_name>GpsGate.Reporting.v3.Provider.MaxColumn</type_name>
              <col_name>MaxSpeed</col_name>
              <col_description></col_description>
              <col_custom_data></col_custom_data>
              <col_data_field>Speed</col_data_field>
              <col_data_field_type>System.Double</col_data_field_type>
              <col_data_store_slot>dbl_03</col_data_store_slot>
              <col_data_store_table>reportv3_data_store</col_data_store_table>
            </Column>
            <Column>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <type_name>GpsGate.Reporting.v3.Provider.AverageColumn</type_name>
              <col_name>AvgSpeed</col_name>
              <col_description></col_description>
              <col_custom_data></col_custom_data>
              <col_data_field>Speed</col_data_field>
              <col_data_field_type>System.Double</col_data_field_type>
              <col_data_store_slot>dbl_04</col_data_store_slot>
              <col_data_store_table>reportv3_data_store</col_data_store_table>
            </Column>
            <Column>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <type_name>GpsGate.Reporting.v3.Provider.FuelColumn</type_name>
              <col_name>Fuel</col_name>
              <col_description></col_description>
              <col_custom_data></col_custom_data>
              <col_data_field>Fuel level</col_data_field>
              <col_data_field_type>System.Double</col_data_field_type>
              <col_data_store_slot>dbl_05</col_data_store_slot>
              <col_data_store_table>reportv3_data_store</col_data_store_table>
            </Column>
            <Column>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <type_name>GpsGate.Reporting.v3.Provider.AverageColumn</type_name>
              <col_name>AvgTemp</col_name>
              <col_description></col_description>
              <col_custom_data></col_custom_data>
              <col_data_field>Temperature</col_data_field>
              <col_data_field_type>System.Double</col_data_field_type>
              <col_data_store_slot>dbl_06</col_data_store_slot>
              <col_data_store_table>reportv3_data_store</col_data_store_table>
            </Column>
            <Column>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <type_name>GpsGate.Reporting.v3.Provider.MaxColumn</type_name>
              <col_name>MaxTemp</col_name>
              <col_description></col_description>
              <col_custom_data></col_custom_data>
              <col_data_field>Temperature</col_data_field>
              <col_data_field_type>System.Double</col_data_field_type>
              <col_data_store_slot>dbl_07</col_data_store_slot>
              <col_data_store_table>reportv3_data_store</col_data_store_table>
            </Column>
            <Column>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <type_name>GpsGate.Reporting.v3.Provider.MinColumn</type_name>
              <col_name>MinTemp</col_name>
              <col_description></col_description>
              <col_custom_data></col_custom_data>
              <col_data_field>Temperature</col_data_field>
              <col_data_field_type>System.Double</col_data_field_type>
              <col_data_store_slot>dbl_08</col_data_store_slot>
              <col_data_store_table>reportv3_data_store</col_data_store_table>
            </Column>
            <Column>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <type_name>GpsGate.Reporting.v3.Provider.ValueColumn</type_name>
              <col_name>FatPointState</col_name>
              <col_description></col_description>
              <col_custom_data>Last</col_custom_data>
              <col_data_field>FatPointState</col_data_field>
              <col_data_field_type>System.String</col_data_field_type>
              <col_data_store_slot>txt_03</col_data_store_slot>
              <col_data_store_table>reportv3_data_store</col_data_store_table>
            </Column>
          </Columns>
        </ReportDataProvider>
      </ObjectData>
    </Object>
  </Template>
  <Template>
    <Object>
      <TemplateGuid>47159920-bcc5-4c90-883d-a09164379163</TemplateGuid>
      <TemplateVersion>1</TemplateVersion>
      <ObjectType>GpsGate.Reporting.v3.ReportDefinitionWriter</ObjectType>
      <ObjectData>
        <ReportDefinition>
          <Name>TR1000 Trip &amp; Idle detailed with Temp (Tag)</Name>
          <ScopeID>4890ff26-bbc6-4cfc-9dc4-30169e308257</ScopeID>
          <Description>Detailed Trip &amp; Idle report with Temperature, per Tag</Description>
          <AppTemplate>00000000-0000-0000-0000-000000000000</AppTemplate>
          <Query>3c44880b-df38-4d0e-a32e-2bcd79a3ca77</Query>
          <TableDefinition defaultStyles="false">
            <pageDefinition>
              <pageFormat>Auto</pageFormat>
              <columnWidths>
                <double>0</double>
                <double>0</double>
                <double>0</double>
                <double>0</double>
                <double>0</double>
                <double>0</double>
                <double>0</double>
                <double>0</double>
                <double>0</double>
                <double>0</double>
                <double>0</double>
              </columnWidths>
            </pageDefinition>
            <Columns />
            <Regions>
              <Region repeatHeader="false" pageBreak="false" expression="" level="0" sortExpression="[SamplingStart]" sortDirection="ASC">
                <Header kind="h">
                  <RegionRow id="h_0_0" VisibilityExpression="true">
                    <Column expression="Period start:" visibilityExpression="" action="" id="h_0_0_0" cspan="1" unit="SHORT_DATE" escape="true">
                      <Layout style="font-size:10pt;font-family:Arial, Helvetica, sans-serif;padding:4px 0px 4px 0px" />
                    </Column>
                    <Column expression="[PeriodStart]" visibilityExpression="" action="" id="h_0_0_1" cspan="10" unit="LONG_DATE" escape="true">
                      <Layout style="font-size:10pt;font-weight:bold;font-family:Arial, Helvetica, sans-serif;padding:4px 0px 4px 9px" />
                    </Column>
                  </RegionRow>
                  <RegionRow id="h_0_1" VisibilityExpression="true">
                    <Column expression="Period end:" visibilityExpression="" action="" id="h_0_1_0" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;font-family:Arial, Helvetica, sans-serif;padding:4px 0px 4px 0px" />
                    </Column>
                    <Column expression="[PeriodEnd]" visibilityExpression="" action="" id="h_0_1_1" cspan="10" unit="LONG_DATE" escape="true">
                      <Layout style="font-size:10pt;font-weight:bold;font-family:Arial, Helvetica, sans-serif;padding:4px 0px 4px 9px" />
                    </Column>
                  </RegionRow>
                  <RegionRow id="h_0_2" VisibilityExpression="true">
                    <Column expression="Total vehicles:" visibilityExpression="" action="" id="h_0_2_0" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;font-family:Arial, Helvetica, sans-serif;padding:4px 0px 4px 0px" />
                    </Column>
                    <Column expression="$countunique([UserID])" visibilityExpression="" action="" id="h_0_2_1" cspan="10" unit="" escape="true">
                      <Layout style="font-size:10pt;font-weight:bold;font-family:Arial, Helvetica, sans-serif;padding:4px 0px 4px 9px" />
                    </Column>
                  </RegionRow>
                  <RegionRow id="h_0_3" VisibilityExpression="true">
                    <Column expression="Total duration idle:" visibilityExpression="" action="" id="h_0_3_0" cspan="1" unit="" escape="true">
                      <Layout style="padding:4px 0px 4px 0px" />
                    </Column>
                    <Column expression="$sum([IdleDuration])" visibilityExpression="" action="" id="h_0_3_1" cspan="10" unit="SHORT_TIME_SPAN" escape="true">
                      <Layout style="font-weight:bold;padding:4px 0px 4px 9px" />
                    </Column>
                  </RegionRow>
                  <RegionRow id="h_0_4" VisibilityExpression="true">
                    <Column expression="Total distance:" visibilityExpression="" action="" id="h_0_4_0" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:0px 0px 1px 0px;padding:4px 0px 9px 0px" />
                    </Column>
                    <Column expression="$sum([DistanceGps])" visibilityExpression="" action="" id="h_0_4_1" cspan="10" unit="TRACK_DISTANCE" escape="true">
                      <Layout style="font-size:10pt;font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:0px 0px 1px 0px;padding:4px 0px 9px 9px" />
                    </Column>
                  </RegionRow>
                  <RegionRow id="h_0_5" VisibilityExpression="true">
                    <Column expression="* Idle = Time a vehicle is online and while standing still." visibilityExpression="" action="" id="h_0_5_0" cspan="11" unit="" escape="true">
                      <Layout style="font-size:8pt;font-style:italic;font-family:Arial, Helvetica, sans-serif;padding:16px 0px 4px 0px" />
                    </Column>
                  </RegionRow>
                  <RegionRow id="h_0_6" VisibilityExpression="true">
                    <Column expression="* Trip = Time that a vehicle is online and moving." visibilityExpression="" action="" id="h_0_6_0" cspan="11" unit="" escape="true">
                      <Layout style="font-size:8pt;font-style:italic;font-family:Arial, Helvetica, sans-serif;padding:0px 0px 16px 0px" />
                    </Column>
                  </RegionRow>
                </Header>
                <Item kind="i">
                  <RegionRow id="i_0_0" VisibilityExpression="[$if([FatPointState]='idle')]false[$else]true[$end]">
                    <Column expression="[SamplingStart]" visibilityExpression="" action="{&quot;name&quot;:&quot;Draw Track&quot;,&quot;action&quot;:&quot;drawTrack&quot;,&quot;trigger&quot;:&quot;onclick&quot;,&quot;params&quot;:[&quot;[UserID]&quot;,&quot;[SamplingStart]&quot;,&quot;[SamplingEnd]&quot;]}" id="i_0_0_0" cspan="1" unit="SHORT_DATE_TIME" escape="true">
                      <Layout style="font-size:10pt;font-family:Arial, Helvetica, sans-serif;padding:12px 9px 4px 9px" />
                    </Column>
                    <Column expression="[SamplingEnd]" visibilityExpression="" action="" id="i_0_0_1" cspan="1" unit="SHORT_TIME" escape="true">
                      <Layout style="font-size:10pt;font-family:Arial, Helvetica, sans-serif;padding:12px 9px 4px 9px" />
                    </Column>
                    <Column expression="[Duration]" visibilityExpression="" action="" id="i_0_0_2" cspan="1" unit="SHORT_TIME_SPAN" escape="true">
                      <Layout style="font-size:10pt;font-family:Arial, Helvetica, sans-serif;padding:12px 9px 4px 9px" />
                    </Column>
                    <Column expression="[StartAddress]" visibilityExpression="" action="{&quot;name&quot;:&quot;Show Marker&quot;,&quot;action&quot;:&quot;showMarker&quot;,&quot;trigger&quot;:&quot;onclick&quot;,&quot;params&quot;:[&quot;[UserID]&quot;,&quot;[SamplingStart]&quot;]}" id="i_0_0_3" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;font-family:Arial, Helvetica, sans-serif;padding:12px 9px 4px 9px" />
                    </Column>
                    <Column expression="[DistanceGps]" visibilityExpression="" action="" id="i_0_0_4" cspan="1" unit="TRACK_DISTANCE" escape="true">
                      <Layout style="font-size:10pt;font-family:Arial, Helvetica, sans-serif;padding:12px 9px 4px 9px" />
                    </Column>
                    <Column expression="[MaxTemp]" visibilityExpression="" action="" id="i_0_0_5" cspan="1" unit="SIGNAL_TEMPERATURE" escape="true">
                      <Layout style="font-size:10pt;font-family:Arial, Helvetica, sans-serif;padding:12px 9px 4px 9px" />
                    </Column>
                    <Column expression="[MinTemp]" visibilityExpression="" action="" id="i_0_0_6" cspan="1" unit="SIGNAL_TEMPERATURE" escape="true">
                      <Layout style="font-size:10pt;font-family:Arial, Helvetica, sans-serif;padding:12px 9px 4px 9px" />
                    </Column>
                    <Column expression="[AvgTemp]" visibilityExpression="" action="" id="i_0_0_7" cspan="1" unit="SIGNAL_TEMPERATURE" escape="true">
                      <Layout style="font-size:10pt;font-family:Arial, Helvetica, sans-serif;padding:12px 9px 4px 9px" />
                    </Column>
                    <Column expression="[MaxSpeed]" visibilityExpression="" action="" id="i_0_0_8" cspan="1" unit="REPORT_SPEED" escape="true">
                      <Layout style="font-size:10pt;font-family:Arial, Helvetica, sans-serif;padding:12px 9px 4px 9px" />
                    </Column>
                    <Column expression="[AvgSpeed]" visibilityExpression="" action="" id="i_0_0_9" cspan="1" unit="REPORT_SPEED" escape="true">
                      <Layout style="font-size:10pt;font-family:Arial, Helvetica, sans-serif;padding:12px 9px 4px 9px" />
                    </Column>
                    <Column expression="[FatPointState]" visibilityExpression="" action="" id="i_0_0_10" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#3E9819;font-family:Arial, Helvetica, sans-serif;padding:12px 9px 4px 9px" />
                    </Column>
                  </RegionRow>
                  <RegionRow id="i_0_1" VisibilityExpression="[$if([FatPointState]='run')]false[$else]true[$end]">
                    <Column expression="[SamplingStart]" visibilityExpression="" action="{&quot;name&quot;:&quot;Draw Track&quot;,&quot;action&quot;:&quot;drawTrack&quot;,&quot;trigger&quot;:&quot;onclick&quot;,&quot;params&quot;:[&quot;[UserID]&quot;,&quot;[SamplingStart]&quot;,&quot;[SamplingEnd]&quot;]}" id="i_0_1_0" cspan="1" unit="SHORT_DATE_TIME" escape="true">
                      <Layout style="font-size:10pt;color:#7D7D7D;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:4px 9px 12px 9px" />
                    </Column>
                    <Column expression="[SamplingEnd]" visibilityExpression="" action="" id="i_0_1_1" cspan="1" unit="SHORT_TIME" escape="true">
                      <Layout style="font-size:10pt;color:#7D7D7D;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:4px 9px 12px 9px" />
                    </Column>
                    <Column expression="[Duration]" visibilityExpression="" action="" id="i_0_1_2" cspan="1" unit="SHORT_TIME_SPAN" escape="true">
                      <Layout style="font-size:10pt;color:#7D7D7D;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:4px 9px 12px 9px" />
                    </Column>
                    <Column expression="[StopAddress]" visibilityExpression="" action="{&quot;name&quot;:&quot;Show Marker&quot;,&quot;action&quot;:&quot;showMarker&quot;,&quot;trigger&quot;:&quot;onclick&quot;,&quot;params&quot;:[&quot;[UserID]&quot;,&quot;[SamplingEnd]&quot;]}" id="i_0_1_3" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#7D7D7D;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:4px 9px 12px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="i_0_1_4" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#7D7D7D;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:4px 9px 12px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="i_0_1_5" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#7D7D7D;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:4px 9px 12px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="i_0_1_6" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#7D7D7D;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:4px 9px 12px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="i_0_1_7" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#7D7D7D;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:4px 9px 12px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="i_0_1_8" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#7D7D7D;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:4px 9px 12px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="i_0_1_9" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#7D7D7D;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:4px 9px 12px 9px" />
                    </Column>
                    <Column expression="[FatPointState]" visibilityExpression="" action="" id="i_0_1_10" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#F4AF2F;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:4px 9px 12px 9px" />
                    </Column>
                  </RegionRow>
                </Item>
                <Footer kind="f">
                  <RegionRow id="f_0_0" VisibilityExpression="true">
                    <Column expression="" visibilityExpression="" action="" id="f_0_0_0" cspan="1" escape="true">
                      <Layout style="padding:0px 0px 24px 0px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_0_0_1" cspan="1" escape="true">
                      <Layout style="" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_0_0_2" cspan="1" unit="" escape="true">
                      <Layout style="" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_0_0_3" cspan="1" unit="" escape="true">
                      <Layout style="" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_0_0_4" cspan="1" unit="" escape="true">
                      <Layout style="" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_0_0_5" cspan="1" unit="" escape="true">
                      <Layout style="" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_0_0_6" cspan="1" unit="" escape="true">
                      <Layout style="" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_0_0_7" cspan="1" unit="" escape="true">
                      <Layout style="" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_0_0_8" cspan="1" unit="" escape="true">
                      <Layout style="" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_0_0_9" cspan="1" unit="" escape="true">
                      <Layout style="" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_0_0_10" cspan="1" escape="true">
                      <Layout style="" />
                    </Column>
                  </RegionRow>
                </Footer>
              </Region>
              <Region repeatHeader="false" pageBreak="false" expression="[UserID]" level="1" sortExpression="[Name]" sortDirection="ASC">
                <Header kind="h">
                  <RegionRow id="h_1_0" VisibilityExpression="true">
                    <Column expression="[Name]" visibilityExpression="" action="" id="h_1_0_0" cspan="11" unit="" escape="true">
                      <Layout style="font-size:16pt;font-family:Arial, Helvetica, sans-serif;padding:9px 0px 16px 0px" />
                    </Column>
                  </RegionRow>
                  <RegionRow id="h_1_1" VisibilityExpression="true">
                    <Column expression="Total duration trip:" visibilityExpression="" action="" id="h_1_1_0" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;font-family:Arial, Helvetica, sans-serif;padding:4px 0px 4px 0px" />
                    </Column>
                    <Column expression="$sum([TripTime])" visibilityExpression="" action="" id="h_1_1_1" cspan="10" unit="LONG_TIME_SPAN" escape="true">
                      <Layout style="font-size:10pt;font-weight:bold;font-family:Arial, Helvetica, sans-serif;padding:4px 0px 4px 9px" />
                    </Column>
                  </RegionRow>
                  <RegionRow id="h_1_2" VisibilityExpression="true">
                    <Column expression="Total duration idle:" visibilityExpression="" action="" id="h_1_2_0" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;font-family:Arial, Helvetica, sans-serif;padding:4px 0px 4px 0px" />
                    </Column>
                    <Column expression="$sum([IdleDuration])" visibilityExpression="" action="" id="h_1_2_1" cspan="10" unit="SHORT_TIME_SPAN" escape="true">
                      <Layout style="font-size:10pt;font-weight:bold;font-family:Arial, Helvetica, sans-serif;padding:4px 0px 4px 9px" />
                    </Column>
                  </RegionRow>
                  <RegionRow id="h_1_3" VisibilityExpression="true">
                    <Column expression="Total distance:" visibilityExpression="" action="" id="h_1_3_0" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;font-family:Arial, Helvetica, sans-serif;padding:4px 0px 16px 0px" />
                    </Column>
                    <Column expression="$sum([DistanceGps])" visibilityExpression="" action="" id="h_1_3_1" cspan="10" unit="TRACK_DISTANCE" escape="true">
                      <Layout style="font-size:10pt;font-weight:bold;font-family:Arial, Helvetica, sans-serif;padding:4px 0px 16px 9px" />
                    </Column>
                  </RegionRow>
                  <RegionRow id="h_1_4" VisibilityExpression="true">
                    <Column expression="Start Time" visibilityExpression="" action="" id="h_1_4_0" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7C7C7C;background-color:#F8F8F8;font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7C7C7C;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="Stop Time" visibilityExpression="" action="" id="h_1_4_1" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7C7C7C;background-color:#F8F8F8;font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7C7C7C;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="Duration" visibilityExpression="" action="" id="h_1_4_2" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7C7C7C;background-color:#F8F8F8;font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7C7C7C;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="Address" visibilityExpression="" action="" id="h_1_4_3" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7C7C7C;background-color:#F8F8F8;font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7C7C7C;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="Distance (GPS)" visibilityExpression="" action="" id="h_1_4_4" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7C7C7C;background-color:#F8F8F8;font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7C7C7C;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="MaxTemp" visibilityExpression="" action="" id="h_1_4_5" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7C7C7C;background-color:#F8F8F8;font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7C7C7C;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="MinTemp" visibilityExpression="" action="" id="h_1_4_6" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7C7C7C;background-color:#F8F8F8;font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7C7C7C;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="AvgTemp" visibilityExpression="" action="" id="h_1_4_7" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7C7C7C;background-color:#F8F8F8;font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7C7C7C;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="Max Speed" visibilityExpression="" action="" id="h_1_4_8" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7C7C7C;background-color:#F8F8F8;font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7C7C7C;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="Avg Speed" visibilityExpression="" action="" id="h_1_4_9" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7C7C7C;background-color:#F8F8F8;font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7C7C7C;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="Trip/Idle*" visibilityExpression="" action="" id="h_1_4_10" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7C7C7C;background-color:#F8F8F8;font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7C7C7C;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                  </RegionRow>
                </Header>
                <Item kind="i" />
                <Footer kind="f">
                  <RegionRow id="f_1_0" VisibilityExpression="$Math.eval('$last([FatPointState])' == 'run' ? 'true' : 'false')">
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_0" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#7D7D7D;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:4px 9px 12px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_1" cspan="1" unit="SHORT_TIME" escape="true">
                      <Layout style="font-size:10pt;color:#7D7D7D;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:4px 9px 12px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_2" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#7D7D7D;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:4px 9px 12px 9px" />
                    </Column>
                    <Column expression="$last([StopAddress])" visibilityExpression="" action="" id="f_1_0_3" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#7D7D7D;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:4px 9px 12px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_4" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#7D7D7D;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:4px 9px 12px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_5" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#7D7D7D;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:4px 9px 12px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_6" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#7D7D7D;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:4px 9px 12px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_7" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#7D7D7D;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:4px 9px 12px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_8" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#7D7D7D;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:4px 9px 12px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_9" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#7D7D7D;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:4px 9px 12px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_10" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#7D7D7D;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:4px 9px 12px 9px" />
                    </Column>
                  </RegionRow>
                  <RegionRow id="f_1_1" VisibilityExpression="true">
                    <Column expression="" visibilityExpression="" action="" id="f_1_1_0" cspan="1" unit="" escape="true">
                      <Layout style="font-weight:bold;border:solid #7D7D7D;border-width:1px 0px 0px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_1_1" cspan="1" unit="" escape="true">
                      <Layout style="font-weight:bold;border:solid #7D7D7D;border-width:1px 0px 0px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="$sum([Duration])" visibilityExpression="" action="" id="f_1_1_2" cspan="1" unit="SHORT_TIME_SPAN" escape="true">
                      <Layout style="font-weight:bold;border:solid #7D7D7D;border-width:1px 0px 0px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_1_3" cspan="1" unit="" escape="true">
                      <Layout style="font-weight:bold;border:solid #7D7D7D;border-width:1px 0px 0px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="$sum([DistanceGps])" visibilityExpression="" action="" id="f_1_1_4" cspan="1" unit="TRACK_DISTANCE" escape="true">
                      <Layout style="font-weight:bold;border:solid #7D7D7D;border-width:1px 0px 0px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_1_5" cspan="1" unit="" escape="true">
                      <Layout style="font-weight:bold;border:solid #7D7D7D;border-width:1px 0px 0px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_1_6" cspan="1" unit="" escape="true">
                      <Layout style="font-weight:bold;border:solid #7D7D7D;border-width:1px 0px 0px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_1_7" cspan="1" unit="" escape="true">
                      <Layout style="font-weight:bold;border:solid #7D7D7D;border-width:1px 0px 0px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="$max([MaxSpeed])" visibilityExpression="" action="" id="f_1_1_8" cspan="1" unit="REPORT_SPEED" escape="true">
                      <Layout style="font-weight:bold;border:solid #7D7D7D;border-width:1px 0px 0px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="$avg([AvgSpeed])" visibilityExpression="" action="" id="f_1_1_9" cspan="1" unit="REPORT_SPEED" escape="true">
                      <Layout style="font-weight:bold;border:solid #7D7D7D;border-width:1px 0px 0px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_1_10" cspan="1" unit="" escape="true">
                      <Layout style="font-weight:bold;border:solid #7D7D7D;border-width:1px 0px 0px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                  </RegionRow>
                  <RegionRow id="f_1_2" VisibilityExpression="true">
                    <Column expression="" visibilityExpression="" action="" id="f_1_2_0" cspan="11" unit="" escape="true">
                      <Layout style="font-size:10pt;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:2px 0px 0px 0px;padding:0px 0px 16px 0px" />
                    </Column>
                  </RegionRow>
                </Footer>
              </Region>
            </Regions>
          </TableDefinition>
        </ReportDefinition>
      </ObjectData>
    </Object>
    <Object>
      <TemplateGuid>3c44880b-df38-4d0e-a32e-2bcd79a3ca77</TemplateGuid>
      <TemplateVersion>16</TemplateVersion>
      <ObjectType>GpsGate.Reporting.v3.QueryWriter</ObjectType>
      <ObjectData>
        <Query>
          <Name>DistanceDetailed</Name>
          <ScopeID>4890ff26-bbc6-4cfc-9dc4-30169e308257</ScopeID>
          <QueryText>SELECT 
	CAST([PeriodStart] AS DATETIME) AS PeriodStart,
	CAST([PeriodEnd] AS DATETIME) AS PeriodEnd,
	[ApplicationID] AS ApplicationID,
	Users.Username,
	Users.Name,
	TIME_TO_SEC(TIMEDIFF(DistanceAndTemp.SamplingEnd, DistanceAndTemp.SamplingStart)) AS Duration,
	CASE DistanceAndTemp.FatPointState WHEN 'idle' 
		THEN TIME_TO_SEC(TIMEDIFF(DistanceAndTemp.SamplingEnd, DistanceAndTemp.SamplingStart))
		ELSE 0 END AS IdleDuration,
	CASE DistanceAndTemp.FatPointState WHEN 'run' 
		THEN TIME_TO_SEC(TIMEDIFF(DistanceAndTemp.SamplingEnd, DistanceAndTemp.SamplingStart))
		ELSE 0 END AS TripTime,
	DistanceAndTemp.SamplingStart,
	DistanceAndTemp.SamplingEnd,
	DistanceAndTemp.UserID,
	DistanceAndTemp.StartAddress,
	DistanceAndTemp.StopAddress,
	DistanceAndTemp.DistanceGps,
	DistanceAndTemp.DistanceOdo,
	DistanceAndTemp.MaxTemp,
	DistanceAndTemp.AvgTemp,
	DistanceAndTemp.MinTemp,
	DistanceAndTemp.MaxSpeed,
	CASE WHEN DistanceAndTemp.DistanceGps &gt; 0 AND TIME_TO_SEC(TIMEDIFF(DistanceAndTemp.SamplingEnd, DistanceAndTemp.SamplingStart)) &gt; 0 THEN
		DistanceAndTemp.DistanceGps / TIME_TO_SEC(TIMEDIFF(DistanceAndTemp.SamplingEnd, DistanceAndTemp.SamplingStart)) 
	ELSE
		0
	END AS AvgSpeed,
	DistanceAndTemp.FatPointState,
	DistanceAndTemp.Fuel
FROM DistanceAndTemp
	JOIN Users ON Users.UserID = DistanceAndTemp.UserID
WHERE DistanceAndTemp.UserID IN (SELECT UserID FROM TagUsers WHERE TagUsers.TagID IN [TagID])
	AND DistanceAndTemp.SamplingStart &gt;= [PeriodStart] 
	AND DistanceAndTemp.SamplingStart &lt;= [PeriodEnd]
	AND DistanceAndTemp.FatPointState != 'sleep'
	ORDER BY DistanceAndTemp.UserID, DistanceAndTemp.SamplingStart</QueryText>
          <QueryTextAlt1>SELECT 
	CAST([PeriodStart] AS DATETIME) AS PeriodStart,
	CAST([PeriodEnd] AS DATETIME) AS PeriodEnd,
	[ApplicationID] AS ApplicationID,
	Users.Username,
	Users.Name,
	DATEDIFF(SECOND, DistanceAndTemp.SamplingStart, DistanceAndTemp.SamplingEnd) AS Duration,
	CASE DistanceAndTemp.FatPointState WHEN 'idle' 
		THEN DATEDIFF(SECOND, DistanceAndTemp.SamplingStart, DistanceAndTemp.SamplingEnd)
		ELSE 0 END AS IdleDuration,
	CASE DistanceAndTemp.FatPointState WHEN 'run' 
		THEN DATEDIFF(SECOND, DistanceAndTemp.SamplingStart, DistanceAndTemp.SamplingEnd)
		ELSE 0 END AS TripTime,
	DistanceAndTemp.SamplingStart,
	DistanceAndTemp.SamplingEnd,
	DistanceAndTemp.UserID,
	DistanceAndTemp.StartAddress,
	DistanceAndTemp.StopAddress,
	DistanceAndTemp.DistanceGps,
	DistanceAndTemp.DistanceOdo,
	DistanceAndTemp.MaxTemp,
	DistanceAndTemp.AvgTemp,
	DistanceAndTemp.MinTemp,
	DistanceAndTemp.MaxSpeed,
	CASE WHEN DistanceAndTemp.DistanceGps &gt; 0 AND DATEDIFF(SECOND, DistanceAndTemp.SamplingStart, DistanceAndTemp.SamplingEnd) &gt; 0 THEN
		DistanceAndTemp.DistanceGps / DATEDIFF(SECOND, DistanceAndTemp.SamplingStart, DistanceAndTemp.SamplingEnd) 
	ELSE
		0
	END AS AvgSpeed,
	DistanceAndTemp.FatPointState,
	DistanceAndTemp.Fuel
FROM DistanceAndTemp
	JOIN Users ON Users.UserID = DistanceAndTemp.UserID
WHERE DistanceAndTemp.UserID IN (SELECT UserID FROM TagUsers WHERE TagUsers.TagID IN [TagID])
	AND DistanceAndTemp.SamplingStart &gt;= [PeriodStart] 
	AND DistanceAndTemp.SamplingStart &lt;= [PeriodEnd]
	AND DistanceAndTemp.FatPointState != 'sleep'
	ORDER BY DistanceAndTemp.UserID, DistanceAndTemp.SamplingStart</QueryTextAlt1>
          <IsInternal>False</IsInternal>
          <Type>GpsGate.Reporting.v3.UserQuery</Type>
          <Parameters>
            <Parameter>
              <type_name>GpsGate.Reporting.v3.QueryReportSqlParameter</type_name>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <param_name>ApplicationID</param_name>
              <multi>False</multi>
              <value_field>ApplicationID</value_field>
              <label_field>Name</label_field>
              <user_def_value>Applications</user_def_value>
              <data_type>System.Int32</data_type>
              <default_value></default_value>
            </Parameter>
            <Parameter>
              <type_name>GpsGate.Reporting.v3.PeriodReportSqlParameter</type_name>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <param_name>Period</param_name>
              <multi>False</multi>
              <data_type>System.DateTime</data_type>
              <default_value>-1</default_value>
            </Parameter>
            <Parameter>
              <type_name>GpsGate.Reporting.v3.QueryReportSqlParameter</type_name>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <param_name>TagID</param_name>
              <multi>True</multi>
              <value_field>TagID</value_field>
              <label_field>Name</label_field>
              <user_def_value>Tags</user_def_value>
              <data_type>System.Int32</data_type>
              <default_value></default_value>
            </Parameter>
          </Parameters>
        </Query>
      </ObjectData>
    </Object>
  </Template>
</Templates>