<?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>6d30cbb0-8cba-4c6d-8287-27d31b85abbe</TemplateGuid>
      <TemplateVersion>1</TemplateVersion>
      <ObjectType>GpsGate.Reporting.v3.QueryWriter</ObjectType>
      <ObjectData>
        <Query>
          <Name>EcoDistance01</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 'ECO_CruiseDistanceMax', dbl_07 AS 'ECO_CruiseFuelMax', dbl_08 AS 'ECO_CruiseTimeMax', dbl_10 AS 'ECO_TotalDistanceMax', dbl_11 AS 'ECO_TotalFuelMax', dbl_12 AS 'ECO_TotalTimeMax', dbl_09 AS 'ECO_EventType', 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 = 9 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 'ECO_CruiseDistanceMax', dbl_07 AS 'ECO_CruiseFuelMax', dbl_08 AS 'ECO_CruiseTimeMax', dbl_10 AS 'ECO_TotalDistanceMax', dbl_11 AS 'ECO_TotalFuelMax', dbl_12 AS 'ECO_TotalTimeMax', dbl_09 AS 'ECO_EventType', 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 = 9 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>EcoDistance01</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.MaxColumn</type_name>
              <col_name>ECO_CruiseDistanceMax</col_name>
              <col_description></col_description>
              <col_custom_data></col_custom_data>
              <col_data_field>ECO_CruiseDistance</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>ECO_CruiseFuelMax</col_name>
              <col_description></col_description>
              <col_custom_data></col_custom_data>
              <col_data_field>ECO_CruiseFuel</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.MaxColumn</type_name>
              <col_name>ECO_CruiseTimeMax</col_name>
              <col_description></col_description>
              <col_custom_data></col_custom_data>
              <col_data_field>ECO_CruiseTime</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.MaxColumn</type_name>
              <col_name>ECO_TotalDistanceMax</col_name>
              <col_description></col_description>
              <col_custom_data></col_custom_data>
              <col_data_field>ECO_TotalDistance</col_data_field>
              <col_data_field_type>System.Double</col_data_field_type>
              <col_data_store_slot>dbl_10</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>ECO_TotalFuelMax</col_name>
              <col_description></col_description>
              <col_custom_data></col_custom_data>
              <col_data_field>ECO_TotalFuel</col_data_field>
              <col_data_field_type>System.Double</col_data_field_type>
              <col_data_store_slot>dbl_11</col_data_store_slot>
              <col_data_store_table>reportv3_data_store_ext01</col_data_store_table>
            </Column>
            <Column>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <type_name>GpsGate.Reporting.v3.Provider.MaxColumn</type_name>
              <col_name>ECO_TotalTimeMax</col_name>
              <col_description></col_description>
              <col_custom_data></col_custom_data>
              <col_data_field>ECO_TotalTime</col_data_field>
              <col_data_field_type>System.Double</col_data_field_type>
              <col_data_store_slot>dbl_12</col_data_store_slot>
              <col_data_store_table>reportv3_data_store_ext01</col_data_store_table>
            </Column>
            <Column>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <type_name>GpsGate.Reporting.v3.Provider.ValueColumn</type_name>
              <col_name>ECO_EventType</col_name>
              <col_description></col_description>
              <col_custom_data>First</col_custom_data>
              <col_data_field>ECO_EventType</col_data_field>
              <col_data_field_type>System.Double</col_data_field_type>
              <col_data_store_slot>dbl_09</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>62c5d487-def0-4379-adee-12f3606ef32d</TemplateGuid>
      <TemplateVersion>1</TemplateVersion>
      <ObjectType>GpsGate.Reporting.v3.ReportDefinitionWriter</ObjectType>
      <ObjectData>
        <ReportDefinition>
          <Name>EC1004 FMS Eco Driving Report</Name>
          <ScopeID>cad30a9f-2bb6-4392-8370-b5ba10741d68</ScopeID>
          <Description>Daily Cruise Control data, per User</Description>
          <AppTemplate>00000000-0000-0000-0000-000000000000</AppTemplate>
          <Query>699b7e9d-8673-4f89-89da-ec63de488b2a</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>
                <double>0</double>
                <double>0</double>
              </columnWidths>
            </pageDefinition>
            <Columns />
            <Regions>
              <Region repeatHeader="false" pageBreak="false" expression="" level="0" sortExpression="[StartTime]" sortDirection="ASC">
                <Header kind="h">
                  <RegionRow id="h_0_0" VisibilityExpression="true">
                    <Column expression="FMS Eco Driving Report" visibilityExpression="" action="" id="h_0_0_0" cspan="11" unit="" escape="true">
                      <Layout style="font-size:16pt;font-weight:bold;font-style:italic;font-family:Arial, Helvetica, sans-serif;padding:4px 9px 4px 0px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="h_0_0_1" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;font-weight:bold;font-style:italic;font-family:Arial, Helvetica, sans-serif;padding:4px 9px 4px 0px" />
                    </Column>
                  </RegionRow>
                  <RegionRow id="h_0_1" VisibilityExpression="true">
                    <Column expression="" visibilityExpression="" action="" id="h_0_1_0" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;font-family:Arial, Helvetica, sans-serif;padding:0px 0px 16px 0px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="h_0_1_1" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;font-family:Arial, Helvetica, sans-serif;padding:0px 0px 16px 0px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="h_0_1_2" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;font-family:Arial, Helvetica, sans-serif;padding:0px 0px 16px 0px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="h_0_1_3" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;font-family:Arial, Helvetica, sans-serif;padding:0px 0px 16px 0px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="h_0_1_4" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;font-family:Arial, Helvetica, sans-serif;padding:0px 0px 16px 0px" />
                    </Column>
                    <Column expression="&lt;img src=&quot;https://tonygpsgate.server93.com/VehicleTracker/Images/Branding/logo_57@2x.png?t=241023140727&quot; width=&quot;160&quot; height=&quot;45&quot;&gt;" visibilityExpression="" action="" id="h_0_1_5" cspan="6" unit="" escape="false">
                      <Layout style="font-size:8pt;text-align:right;font-family:Arial, Helvetica, sans-serif;padding:0px 0px 16px 0px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="h_0_1_6" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;font-family:Arial, Helvetica, sans-serif;padding:0px 0px 16px 0px" />
                    </Column>
                  </RegionRow>
                </Header>
                <Item kind="i">
                  <RegionRow id="i_0_0" VisibilityExpression="true">
                    <Column expression="[PeriodStart]" visibilityExpression="" action="" id="i_0_0_0" cspan="1" unit="SHORT_DATE" escape="true">
                      <Layout style="font-size:10pt;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:12px 9px 4px 4px" />
                    </Column>
                    <Column expression="[ECO_EventType]" visibilityExpression="" action="" id="i_0_0_1" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;text-align:center;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:12px 9px 4px 4px" />
                    </Column>
                    <Column expression="[ECO_CruiseDistanceMax]" visibilityExpression="" action="" id="i_0_0_2" cspan="1" unit="DISTANCE_MEDIUM" escape="true">
                      <Layout style="font-size:10pt;text-align:center;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:12px 9px 4px 4px" />
                    </Column>
                    <Column expression="[ECO_TotalDistanceMax]" visibilityExpression="" action="" id="i_0_0_3" cspan="1" unit="DISTANCE_MEDIUM" escape="true">
                      <Layout style="font-size:10pt;text-align:center;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:12px 9px 4px 4px" />
                    </Column>
                    <Column expression="[Ratio_Distance]" visibilityExpression="" action="" id="i_0_0_4" cspan="1" unit="NUMBER_PERCENTAGE" escape="true">
                      <Layout style="font-size:10pt;text-align:center;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:12px 9px 4px 4px" />
                    </Column>
                    <Column expression="$math.eval([ECO_CruiseFuelMax]/ 1000) l" visibilityExpression="" action="" id="i_0_0_5" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;text-align:center;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:12px 9px 4px 4px" />
                    </Column>
                    <Column expression="$math.eval([ECO_TotalFuelMax] / 1000) l" visibilityExpression="" action="" id="i_0_0_6" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;text-align:center;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:12px 9px 4px 4px" />
                    </Column>
                    <Column expression="[Ratio_Fuel]" visibilityExpression="" action="" id="i_0_0_7" cspan="1" unit="NUMBER_PERCENTAGE" escape="true">
                      <Layout style="font-size:10pt;text-align:center;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:12px 9px 4px 4px" />
                    </Column>
                    <Column expression="[ECO_CruiseTimeMax]" visibilityExpression="" action="" id="i_0_0_8" cspan="1" unit="SHORT_TIME_SPAN" escape="true">
                      <Layout style="font-size:10pt;text-align:center;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:12px 9px 4px 4px" />
                    </Column>
                    <Column expression="[ECO_TotalTimeMax]" visibilityExpression="" action="" id="i_0_0_9" cspan="1" unit="SHORT_TIME_SPAN" escape="true">
                      <Layout style="font-size:10pt;text-align:center;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:12px 9px 4px 4px" />
                    </Column>
                    <Column expression="[Ratio_Time]" visibilityExpression="" action="" id="i_0_0_10" cspan="1" unit="NUMBER_PERCENTAGE" escape="true">
                      <Layout style="font-size:10pt;text-align:center;font-family:Arial, Helvetica, sans-serif;border:solid #DDDDDD;border-width:0px 0px 1px 0px;padding:12px 9px 4px 4px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="i_0_0_11" cspan="1" unit="" escape="true">
                      <Layout style="" />
                    </Column>
                  </RegionRow>
                </Item>
                <Footer kind="f">
                  <RegionRow id="f_0_0" VisibilityExpression="true">
                    <Column expression="" visibilityExpression="" action="" id="f_0_0_0" cspan="11" escape="true">
                      <Layout style="" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_0_0_1" cspan="1" unit="" 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>
                    <Column expression="" visibilityExpression="" action="" id="h_1_0_1" cspan="1" unit="" escape="true">
                      <Layout style="" />
                    </Column>
                  </RegionRow>
                  <RegionRow id="h_1_1" VisibilityExpression="true">
                    <Column expression="" visibilityExpression="" action="" id="h_1_1_0" cspan="1" unit="" escape="true">
                      <Layout style="" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="h_1_1_1" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7D7D7D;text-align:center;font-family:'Arial Black', Gadget, sans-serif" />
                    </Column>
                    <Column expression="Distance" visibilityExpression="" action="" id="h_1_1_2" cspan="3" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7D7D7D;text-align:center;font-family:'Arial Black', Gadget, sans-serif;border:solid #8C8C8C;border-width:0px 2px 0px 2px" />
                    </Column>
                    <Column expression="Fuel" visibilityExpression="" action="" id="h_1_1_3" cspan="3" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7D7D7D;text-align:center;font-family:'Arial Black', Gadget, sans-serif;border:solid #8C8C8C;border-width:0px 2px 0px 0px" />
                    </Column>
                    <Column expression="Time" visibilityExpression="" action="" id="h_1_1_4" cspan="3" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7D7D7D;text-align:center;font-family:'Arial Black', Gadget, sans-serif;border:solid #8C8C8C;border-width:0px 2px 0px 0px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="h_1_1_5" cspan="1" unit="" escape="true">
                      <Layout style="" />
                    </Column>
                  </RegionRow>
                  <RegionRow id="h_1_2" VisibilityExpression="true">
                    <Column expression="Date" visibilityExpression="" action="" id="h_1_2_0" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7D7D7D;background-color:#F8F8F8;font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="Event Type" visibilityExpression="" action="" id="h_1_2_1" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7D7D7D;background-color:#F8F8F8;font-weight:bold;text-align:center;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="Cruise" visibilityExpression="" action="" id="h_1_2_2" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7D7D7D;background-color:#F8F8F8;font-weight:bold;text-align:center;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:0px 0px 1px 2px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="Total " visibilityExpression="" action="" id="h_1_2_3" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7D7D7D;background-color:#F8F8F8;font-weight:bold;text-align:center;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="Ratio" visibilityExpression="" action="" id="h_1_2_4" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7D7D7D;background-color:#F8F8F8;font-weight:bold;text-align:center;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:0px 2px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="Cruise" visibilityExpression="" action="" id="h_1_2_5" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7D7D7D;background-color:#F8F8F8;font-weight:bold;text-align:center;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="Total" visibilityExpression="" action="" id="h_1_2_6" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7D7D7D;background-color:#F8F8F8;font-weight:bold;text-align:center;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="Ratio" visibilityExpression="" action="" id="h_1_2_7" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7D7D7D;background-color:#F8F8F8;font-weight:bold;text-align:center;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:0px 2px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="Cruise" visibilityExpression="" action="" id="h_1_2_8" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7D7D7D;background-color:#F8F8F8;font-weight:bold;text-align:center;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="Total" visibilityExpression="" action="" id="h_1_2_9" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7D7D7D;background-color:#F8F8F8;font-weight:bold;text-align:center;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="Ratio" visibilityExpression="" action="" id="h_1_2_10" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#7D7D7D;background-color:#F8F8F8;font-weight:bold;text-align:center;font-family:Arial, Helvetica, sans-serif;border:solid #8C8C8C;border-width:0px 2px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="h_1_2_11" cspan="1" unit="" escape="true">
                      <Layout style="" />
                    </Column>
                  </RegionRow>
                </Header>
                <Item kind="i" />
                <Footer kind="f">
                  <RegionRow id="f_1_0" VisibilityExpression="true">
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_0" cspan="1" unit="" escape="true">
                      <Layout style="font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:1px 0px 0px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_1" cspan="1" unit="" escape="true">
                      <Layout style="font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:1px 0px 0px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_2" cspan="1" unit="TRACK_DISTANCE" escape="true">
                      <Layout style="font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:1px 0px 0px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_3" cspan="1" unit="REPORT_SPEED" escape="true">
                      <Layout style="font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:1px 0px 0px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_4" cspan="1" unit="SHORT_TIME_SPAN" escape="true">
                      <Layout style="font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:1px 0px 0px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_5" cspan="1" unit="SHORT_TIME_SPAN" escape="true">
                      <Layout style="font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:1px 0px 0px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_6" cspan="1" unit="" escape="true">
                      <Layout style="font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:1px 0px 0px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_7" cspan="1" unit="" escape="true">
                      <Layout style="font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:1px 0px 0px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_8" cspan="1" unit="" escape="true">
                      <Layout style="font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:1px 0px 0px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_9" cspan="1" unit="" escape="true">
                      <Layout style="font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:1px 0px 0px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_10" cspan="1" unit="SHORT_TIME_SPAN" escape="true">
                      <Layout style="font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #7D7D7D;border-width:1px 0px 0px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_11" cspan="1" unit="" escape="true">
                      <Layout style="" />
                    </Column>
                  </RegionRow>
                </Footer>
              </Region>
            </Regions>
          </TableDefinition>
        </ReportDefinition>
      </ObjectData>
    </Object>
    <Object ReadOnly="True">
      <TemplateGuid>699b7e9d-8673-4f89-89da-ec63de488b2a</TemplateGuid>
      <TemplateVersion>18</TemplateVersion>
      <ObjectType>GpsGate.Reporting.v3.QueryWriter</ObjectType>
      <ObjectData>
        <Query>
          <Name>DistanceDaily</Name>
          <ScopeID>cad30a9f-2bb6-4392-8370-b5ba10741d68</ScopeID>
          <QueryText>SELECT
	PeriodStart,
	PeriodEnd,
	ApplicationID,
	MIN(SamplingStart) AS StartTime,
	MAX(SamplingEnd) AS StopTime,
	Name,
	UserID,
	SUM(Duration) AS TotalDuration,
	SUM(DurationIdle) AS TotalDurationIdle,
	SUM(DurationTrip) AS TotalDurationTrip,
	ROUND(SUM(DurationIdle) / (SUM(DurationIdle) + SUM(DurationTrip)) * 100,1) AS PctIdle,
	SUM(IdleCount) AS TotalIdles,
	SUM(TripCount) AS TotalTrips,
	COUNT(FatPointState) AS TotalTripsIdles,
	MAX(MaxSpeed) AS MaxSpeed,
	SUM(DistanceGps) AS TotalDistanceGps,
	SUM(DistanceOdo) AS TotalDistanceOdo,
	SUM(DistanceGps) / SUM(Duration) AS AvgSpeedGps,
	SUM(DistanceOdo) / SUM(Duration) AS AvgSpeedOdo,

MAX(ECO_CruiseDistanceMax) AS ECO_CruiseDistanceMax,
MAX(ECO_CruiseFuelMax) AS ECO_CruiseFuelMax,
MAX(ECO_CruiseTimeMax) AS ECO_CruiseTimeMax,
MAX(ECO_TotalDistanceMax) AS ECO_TotalDistanceMax,
MAX(ECO_TotalFuelMax) AS ECO_TotalFuelMax,
MAX(ECO_TotalTimeMax) AS ECO_TotalTimeMax,
MAX(ECO_CruiseDistanceMax) / MAX(ECO_TotalDistanceMax) AS Ratio_Distance,
MAX(ECO_CruiseFuelMax) / MAX(ECO_TotalFuelMax) AS Ratio_Fuel,
MAX(ECO_CruiseTimeMax) / MAX(ECO_TotalTimeMax) As Ratio_Time,

CASE
    WHEN ECO_EventType = 0 THEN "Periodic"
    WHEN ECO_EventType = 1 THEN "Trip"
    ELSE " Periodic "
END AS ECO_EventType

FROM DistanceDetailed
GROUP BY 
	UserID,
	Name,
	DATE(DATE_ADD(SamplingStart, INTERVAL [_UTCOFFSET] SECOND))</QueryText>
          <QueryTextAlt1>SELECT
	MIN(PeriodStart) AS PeriodStart,
	MAX(PeriodEnd) AS PeriodEnd,
	MAX(ApplicationID) AS ApplicatinoID,
	MIN(SamplingStart) AS StartTime,
	MAX(SamplingEnd) AS StopTime,
	Name,
	UserID,
	SUM(Duration) AS TotalDuration,
	SUM(DurationIdle) AS TotalDurationIdle,
	SUM(DurationTrip) AS TotalDurationTrip,
	ROUND(CONVERT(DECIMAL, SUM(DurationIdle)) / (CONVERT(DECIMAL, SUM(DurationIdle)) + CONVERT(DECIMAL, SUM(DurationTrip))) * 100,1) AS PctIdle,
	SUM(IdleCount) AS TotalIdles,
	SUM(TripCount) AS TotalTrips,
	COUNT(FatPointState) AS TotalTripsIdles,
	MAX(MaxSpeed) AS MaxSpeed,
	SUM(DistanceGps) AS TotalDistanceGps,
	SUM(DistanceOdo) AS TotalDistanceOdo,
	SUM(DistanceGps) / SUM(Duration) AS AvgSpeedGps,
	SUM(DistanceOdo) / SUM(Duration) AS AvgSpeedOdo
FROM DistanceDetailed
GROUP BY 
	UserID,
	Name,
  CONVERT(date, DATEADD(SECOND, [_UTCOFFSET], 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>User</param_name>
              <multi>True</multi>
              <value_field>UserID</value_field>
              <label_field>Name</label_field>
              <user_def_value>Users</user_def_value>
              <data_type>System.Int32</data_type>
              <default_value></default_value>
            </Parameter>
          </Parameters>
        </Query>
      </ObjectData>
    </Object>
    <Object ReadOnly="True">
      <TemplateGuid>220edc24-88e9-48b6-9563-5d2ce736b892</TemplateGuid>
      <TemplateVersion>13</TemplateVersion>
      <ObjectType>GpsGate.Reporting.v3.QueryWriter</ObjectType>
      <ObjectData>
        <Query>
          <Name>DistanceDetailed</Name>
          <ScopeID>cad30a9f-2bb6-4392-8370-b5ba10741d68</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(EcoDistance01.SamplingEnd, EcoDistance01.SamplingStart)) AS Duration,
	CASE WHEN FatPointState = 'idle' THEN TIME_TO_SEC(TIMEDIFF(EcoDistance01.SamplingEnd, EcoDistance01.SamplingStart)) ELSE 0 END AS DurationIdle,
	CASE WHEN FatPointState = 'run' THEN TIME_TO_SEC(TIMEDIFF(EcoDistance01.SamplingEnd, EcoDistance01.SamplingStart)) ELSE 0 END AS DurationTrip,
	CASE WHEN FatPointState = 'idle' THEN 1 ELSE 0 END AS IdleCount,
	CASE WHEN FatPointState = 'run' THEN 1 ELSE 0 END AS TripCount,
	EcoDistance01.SamplingStart,
	EcoDistance01.SamplingEnd,
	EcoDistance01.UserID,
	EcoDistance01.StartAddress,
	EcoDistance01.StopAddress,
	EcoDistance01.DistanceGps,
	EcoDistance01.DistanceOdo,
	EcoDistance01.MaxSpeed,
	EcoDistance01.AvgSpeed,
	EcoDistance01.FatPointState,
	EcoDistance01.Fuel,

        EcoDistance01.ECO_CruiseDistanceMax,
        EcoDistance01.ECO_CruiseFuelMax,
        EcoDistance01.ECO_CruiseTimeMax,
        EcoDistance01.ECO_EventType,
        EcoDistance01.ECO_TotalDistanceMax,
        EcoDistance01.ECO_TotalFuelMax,
        EcoDistance01.ECO_TotalTimeMax


FROM EcoDistance01
	JOIN Users ON Users.UserID = EcoDistance01.UserID

WHERE EcoDistance01.UserID IN (SELECT UserID FROM Users WHERE Users.UserID IN [User])
	AND EcoDistance01.SamplingStart &gt;= [PeriodStart] 
	AND EcoDistance01.SamplingEnd &lt;= [PeriodEnd]
	AND EcoDistance01.FatPointState != 'sleep'
</QueryText>
          <QueryTextAlt1>SELECT 
	CAST([PeriodStart] AS DATETIME) AS PeriodStart,
	CAST([PeriodEnd] AS DATETIME) AS PeriodEnd,
	[ApplicationID] AS ApplicationID,
	Users.Username,
	Users.Name,
	DATEDIFF(SECOND, Distance01.SamplingStart, Distance01.SamplingEnd) AS Duration,
	CASE WHEN FatPointState = 'idle' THEN DATEDIFF(SECOND, Distance01.SamplingStart, Distance01.SamplingEnd) ELSE 0 END AS DurationIdle,
	CASE WHEN FatPointState = 'run' THEN DATEDIFF(SECOND, Distance01.SamplingStart, Distance01.SamplingEnd) ELSE 0 END AS DurationTrip,
	CASE WHEN FatPointState = 'idle' THEN 1 ELSE 0 END AS IdleCount,
	CASE WHEN FatPointState = 'run' THEN 1 ELSE 0 END AS TripCount,
	Distance01.SamplingStart,
	Distance01.SamplingEnd,
	Distance01.UserID,
	Distance01.StartAddress,
	Distance01.StopAddress,
	Distance01.DistanceGps,
	Distance01.DistanceOdo,
	Distance01.MaxSpeed,
	Distance01.AvgSpeed,
	Distance01.FatPointState,
	Distance01.Fuel
FROM Distance01
	JOIN Users ON Users.UserID = Distance01.UserID
WHERE Distance01.UserID IN (SELECT UserID FROM Users WHERE Users.UserID IN [User])
	AND Distance01.SamplingStart &gt;= [PeriodStart] 
	AND Distance01.SamplingEnd &lt;= [PeriodEnd]
	AND Distance01.FatPointState != 'sleep'</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>User</param_name>
              <multi>True</multi>
              <value_field>UserID</value_field>
              <label_field>Name</label_field>
              <user_def_value>Users</user_def_value>
              <data_type>System.Int32</data_type>
              <default_value></default_value>
            </Parameter>
          </Parameters>
        </Query>
      </ObjectData>
    </Object>
  </Template>
</Templates>