Spreadsheet: 129145d1321469226-excel-2007-date-formula-to-maitain-data-location-upload-sample
Sheet: CRYSTAL_PERSIST

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <[NAME] Version="4" ConsolidateParameter="True" EnableRefreshOrder="False" WebServiceURL="http://boapp:8080/dswsbobje/services/session" CMSName="BOAPP.carolinahandling.com%3A6400"><AddinModuleData ID="WEBI"><Webi_documents><Webi_document Connection_i
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d="1" CUID="UnivCUID=Aefky07UDZFKiXBO2CcvyIk" Document_name="unvFleet_Analyst" CurrentReportDrillActive="False" ReportPath="/Reporting" HasPrompt="0" HasQueryContext="False" bHasPromptToBind="True"><Container ContainerCUID="" ContainerKind="1"/><query_spec
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ification>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;QuerySpecification xmlns:[NAME]/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" d1p1:SamplingMode="None" d1p1:SamplingSize="0" xmlns:d1p1="http://query.busines
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sobjects.com/2007/06/01"&gt;  &lt;QueryBase xsi:type="Query" ID="Combined Query 1" xmlns="http://query.businessobjects.com/2005"&gt;    &lt;QueryResult Key="UnivCUID=Aefky07UDZFKiXBO2CcvyIk.DO7c"&gt;      &lt;Name&gt;Serial Nbr&lt;/Name&gt;    &lt;/QueryRe
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sult&gt;    &lt;QueryResult Key="UnivCUID=Aefky07UDZFKiXBO2CcvyIk.DOa0"&gt;      &lt;Name&gt;Extended Price&lt;/Name&gt;    &lt;/QueryResult&gt;    &lt;QueryCondition QueryConditionOperator="And"&gt;      &lt;Item xsi:type="Filter" FilterOperator="InList"&
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | gt;        &lt;FilteredObject Key="UnivCUID=Aefky07UDZFKiXBO2CcvyIk.DO85"&gt;          &lt;Name&gt;Customer Number&lt;/Name&gt;        &lt;/FilteredObject&gt;        &lt;Operand xsi:type="Values"&gt;          &lt;d1p1:NativeFreeValue xsi:type="xsd:string"&
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | gt;71415901&lt;/d1p1:NativeFreeValue&gt;        &lt;/Operand&gt;      &lt;/Item&gt;      &lt;Item xsi:type="Filter" FilterOperator="Between"&gt;        &lt;FilteredObject Key="UnivCUID=Aefky07UDZFKiXBO2CcvyIk.DO8d"&gt;          &lt;Name&gt;Invoice Date&lt;
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /Name&gt;        &lt;/FilteredObject&gt;        &lt;Operand xsi:type="Prompt" KeepLastValues="true" Constrained="false" HasLov="true" Order="0" d5p1:Optional="false" xmlns:d5p1="http://queryservice.dsws.businessobjects.com/2007/06/01"&gt;          &lt;Ques
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | tion&gt;Enter value(s) for &amp;lt;Invoice Date&amp;gt; (Start)&lt;/Question&gt;        &lt;/Operand&gt;        &lt;Operand xsi:type="Prompt" KeepLastValues="true" Constrained="false" HasLov="true" Order="1" d5p1:Optional="false" xmlns:d5p1="http://queryse
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | rvice.dsws.businessobjects.com/2007/06/01"&gt;          &lt;Question&gt;Enter value(s) for &amp;lt;Invoice Date&amp;gt; (End)&lt;/Question&gt;        &lt;/Operand&gt;      &lt;/Item&gt;      &lt;Item xsi:type="Filter" FilterOperator="InList"&gt;        &lt
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ;FilteredObject Key="UnivCUID=Aefky07UDZFKiXBO2CcvyIk.[NAME];          &lt;Name&gt;Folder Desc&lt;/Name&gt;        &lt;/FilteredObject&gt;        &lt;Operand xsi:type="Values"&gt;          &lt;d1p1:NativeFreeValue xsi:type="xsd:string"&gt;B/D Labor&lt;/d
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1p1:NativeFreeValue&gt;          &lt;d1p1:NativeFreeValue xsi:type="xsd:string"&gt;Breakdown&lt;/d1p1:NativeFreeValue&gt;          &lt;d1p1:NativeFreeValue xsi:type="xsd:string"&gt;Ext Travel&lt;/d1p1:NativeFreeValue&gt;          &lt;d1p1:NativeFreeValue x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | si:type="xsd:string"&gt;PF Job&lt;/d1p1:NativeFreeValue&gt;          &lt;d1p1:NativeFreeValue xsi:type="xsd:string"&gt;Repair Field&lt;/d1p1:NativeFreeValue&gt;          &lt;d1p1:NativeFreeValue xsi:type="xsd:string"&gt;Repair Shop&lt;/d1p1:NativeFreeValue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | &gt;          &lt;d1p1:NativeFreeValue xsi:type="xsd:string"&gt;Scheduled Maintenance&lt;/d1p1:NativeFreeValue&gt;        &lt;/Operand&gt;      &lt;/Item&gt;    &lt;/QueryCondition&gt;  &lt;/QueryBase&gt;  &lt;QueryProperty Name="DuplicatedRows" Activate="
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | true" Value="false" xmlns="http://query.businessobjects.com/2005" /&gt;  &lt;QueryProperty Name="MaxFetchedTime" Activate="true" Value="-1" xmlns="http://query.businessobjects.com/2005" /&gt;  &lt;QueryProperty Name="MaxRowFetched" Activate="true" Value="-
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1" xmlns="http://query.businessobjects.com/2005" /&gt;  &lt;QueryProperty Name="DuplicateRowAggregation" Activate="false" Value="true" xmlns="http://query.businessobjects.com/2005" /&gt;&lt;/QuerySpecification&gt;</query_specification><Data_providers/><Ori
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Date&gt; (Start)" promptID="ROOT.0" valueType="1" promptBindType="1" AllowMultipleValues="False" isOptional="False"><currentPromptValues><disreteValue type="2" value="2011-1-
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1T0:0:0" RowIndex=""/></currentPromptValues></prompt><prompt promptName="Enter value(s) for &lt;Invoice Date&gt; (End)" promptID="ROOT.1" valueType="1" promptBindType="1" AllowMultipleValues="False" isOptional="False"><currentPromptValues><disreteValue typ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e="2" value="2011-1-31T0:0:0" RowIndex=""/></currentPromptValues></prompt></prompts><QueryContexts/><WebiViews><WebiView view_id="1" refresh_order="-1" part_UREF="" part_type="0" Conceal_data_when_saving="False" Keep_user_format="True" Instance_by_user="Fa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | lse" Username="" Logon_User_Instance="False" Refresh_DB="True" Use_Report_Saved_Data="False" Use_specific_instance="False" specific_instance_cuid="" specific_instance_description="" Need_format="False" Custom_view_name="unvFleet_Analyst document" Last_refr
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | esh_status="1" Last_refresh_description="" Last_refresh_time="2011-11-16T13:35:18" Last_refresh_time_taken="11609"><Regions><Region name="HHeading" DataRowCount="1" DataColCount="2"><LayoutManager LinkRows="False" LinkCols="False" Version="1.0" RegionName=
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "HHeading"><CustomRows Axis="Row"/><CustomColumns Axis="Column"/></LayoutManager></Region><Region name="DataGrid" DataRowCount="1" DataColCount="2"><LayoutManager LinkRows="False" LinkCols="True" Version="1.0" RegionName="DataGrid"><CustomRows Axis="Row"/>
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <CustomColumns Axis="Column"/></LayoutManager></Region></Regions></WebiView></WebiViews><PromptBindings><PromptBinding Prompt_Binding_Name="Enter value(s) for &lt;Invoice Date&gt; (Start)" Prompt_Binding_Start_Name="WebiParam_enter_value_s__for__invoice_da
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | te___start__634569422379483721" Is_Start_Custom_Name="False" Prompt_Binding_End_Name="" Is_End_Custom_Name="False" AddDefaultValueList="False" UpdateDefaultValueList="False"/><PromptBinding Prompt_Binding_Name="Enter value(s) for &lt;Invoice Date&gt; (End)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | " Prompt_Binding_Start_Name="WebiParam_enter_value_s__for__invoice_date___end__634569422429912742" Is_Start_Custom_Name="False" Prompt_Binding_End_Name="" Is_End_Custom_Name="False" AddDefaultValueList="False" UpdateDefaultValueList="False"/></PromptBindin
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | gs><DataSourceParameterValues/></Webi_document><Webi_document Connection_id="2" CUID="UnivCUID=Aefky07UDZFKiXBO2CcvyIk" Document_name="unvFleet_Analyst" CurrentReportDrillActive="False" ReportPath="/Reporting" HasPrompt="0" HasQueryContext="False" bHasProm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ptToBind="True"><Container ContainerCUID="" ContainerKind="1"/><query_specification>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;QuerySpecification xmlns:[NAME]/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" d1p1:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SamplingMode="None" d1p1:SamplingSize="0" xmlns:d1p1="http://query.businessobjects.com/2007/06/01"&gt;  &lt;QueryBase xsi:type="Query" ID="Combined Query 1" xmlns="http://query.businessobjects.com/2005"&gt;    &lt;QueryResult Key="UnivCUID=Aefky07UDZFKiXBO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2CcvyIk.DO7c"&gt;      &lt;Name&gt;Serial Nbr&lt;/Name&gt;    &lt;/QueryResult&gt;    &lt;QueryResult Key="UnivCUID=Aefky07UDZFKiXBO2CcvyIk.DOa0"&gt;      &lt;Name&gt;Extended Price&lt;/Name&gt;    &lt;/QueryResult&gt;    &lt;QueryCondition QueryConditionO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | perator="And"&gt;      &lt;Item xsi:type="Filter" FilterOperator="InList"&gt;        &lt;FilteredObject Key="UnivCUID=Aefky07UDZFKiXBO2CcvyIk.DO85"&gt;          &lt;Name&gt;Customer Number&lt;/Name&gt;        &lt;/FilteredObject&gt;        &lt;Operand xsi:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | type="Values"&gt;          &lt;d1p1:NativeFreeValue xsi:type="xsd:string"&gt;71415901&lt;/d1p1:NativeFreeValue&gt;        &lt;/Operand&gt;      &lt;/Item&gt;      &lt;Item xsi:type="Filter" FilterOperator="Between"&gt;        &lt;FilteredObject Key="UnivCU
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ID=Aefky07UDZFKiXBO2CcvyIk.DO8d"&gt;          &lt;Name&gt;Invoice Date&lt;/Name&gt;        &lt;/FilteredObject&gt;        &lt;Operand xsi:type="Prompt" KeepLastValues="true" Constrained="false" HasLov="true" Order="0" d5p1:Optional="false" xmlns:d5p1="http
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ://queryservice.dsws.businessobjects.com/2007/06/01"&gt;          &lt;Question&gt;Enter value(s) for &amp;lt;Invoice Date&amp;gt; (Start)&lt;/Question&gt;        &lt;/Operand&gt;        &lt;Operand xsi:type="Prompt" KeepLastValues="true" Constrained="false
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | " HasLov="true" Order="1" d5p1:Optional="false" xmlns:d5p1="http://queryservice.dsws.businessobjects.com/2007/06/01"&gt;          &lt;Question&gt;Enter value(s) for &amp;lt;Invoice Date&amp;gt; (End)&lt;/Question&gt;        &lt;/Operand&gt;      &lt;/Item&
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | gt;      &lt;Item xsi:type="Filter" FilterOperator="InList"&gt;        &lt;FilteredObject Key="UnivCUID=Aefky07UDZFKiXBO2CcvyIk.[NAME];          &lt;Name&gt;Folder Desc&lt;/Name&gt;        &lt;/FilteredObject&gt;        &lt;Operand xsi:type="Values"&gt;
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | &lt;d1p1:NativeFreeValue xsi:type="xsd:string"&gt;B/D Labor&lt;/d1p1:NativeFreeValue&gt;          &lt;d1p1:NativeFreeValue xsi:type="xsd:string"&gt;Breakdown&lt;/d1p1:NativeFreeValue&gt;          &lt;d1p1:NativeFreeValue xsi:type="xsd:string"&gt;E
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xt Travel&lt;/d1p1:NativeFreeValue&gt;          &lt;d1p1:NativeFreeValue xsi:type="xsd:string"&gt;PF Job&lt;/d1p1:NativeFreeValue&gt;          &lt;d1p1:NativeFreeValue xsi:type="xsd:string"&gt;Repair Field&lt;/d1p1:NativeFreeValue&gt;          &lt;d1p1:[NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | iveFreeValue xsi:type="xsd:string"&gt;Repair Shop&lt;/d1p1:NativeFreeValue&gt;          &lt;d1p1:NativeFreeValue xsi:type="xsd:string"&gt;Scheduled Maintenance&lt;/d1p1:NativeFreeValue&gt;        &lt;/Operand&gt;      &lt;/Item&gt;    &lt;/QueryCondition&g
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | t;  &lt;/QueryBase&gt;  &lt;QueryProperty Name="DuplicatedRows" Activate="true" Value="false" xmlns="http://query.businessobjects.com/2005" /&gt;  &lt;QueryProperty Name="MaxFetchedTime" Activate="true" Value="-1" xmlns="http://query.businessobjects.com/20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 05" /&gt;  &lt;QueryProperty Name="MaxRowFetched" Activate="true" Value="-1" xmlns="http://query.businessobjects.com/2005" /&gt;  &lt;QueryProperty Name="DuplicateRowAggregation" Activate="false" Value="true" xmlns="http://query.businessobjects.com/2005" /
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | &gt;&lt;/QuerySpecification&gt;</query_specification><Data_providers/><Original_data_providers/><prompts><prompt promptName="Enter value(s) for &lt;Invoice Date&gt; (Start)" promptID="ROOT.0" valueType="1" promptBindType="1" AllowMultipleValues="False" isO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ptional="False"><currentPromptValues><disreteValue type="2" value="2011-2-1T0:0:0" RowIndex=""/></currentPromptValues></prompt><prompt promptName="Enter value(s) for &lt;Invoice Date&gt; (End)" promptID="ROOT.1" valueType="1" promptBindType="1" AllowMultip
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | leValues="False" isOptional="False"><currentPromptValues><disreteValue type="2" value="2011-2-28T0:0:0" RowIndex=""/></currentPromptValues></prompt></prompts><QueryContexts/><WebiViews><WebiView view_id="1" refresh_order="-1" part_UREF="" part_type="0" Con
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ceal_data_when_saving="False" Keep_user_format="True" Instance_by_user="False" Username="" Logon_User_Instance="False" Refresh_DB="True" Use_Report_Saved_Data="False" Use_specific_instance="False" specific_instance_cuid="" specific_instance_description=""
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Need_format="False" Custom_view_name="unvFleet_Analyst document (1)" Last_refresh_status="1" Last_refresh_description="" Last_refresh_time="2011-11-16T13:35:18" Last_refresh_time_taken="11609"><Regions><Region name="HHeading" DataRowCount="1" DataColCount=
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "2"><LayoutManager LinkRows="False" LinkCols="False" Version="1.0" RegionName="HHeading"><CustomRows Axis="Row"/><CustomColumns Axis="Column"/></LayoutManager></Region><Region name="DataGrid" DataRowCount="1" DataColCount="2"><LayoutManager LinkRows="False
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | " LinkCols="True" Version="1.0" RegionName="DataGrid"><CustomRows Axis="Row"/><CustomColumns Axis="Column"/></LayoutManager></Region></Regions></WebiView></WebiViews><PromptBindings><PromptBinding Prompt_Binding_Name="Enter value(s) for &lt;Invoice Date&gt
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ; (Start)" Prompt_Binding_Start_Name="WebiParam_enter_value_s__for__invoice_date___start__634569426733032784" Is_Start_Custom_Name="False" Prompt_Binding_End_Name="" Is_End_Custom_Name="False" AddDefaultValueList="False" UpdateDefaultValueList="False"/><Pr
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | omptBinding Prompt_Binding_Name="Enter value(s) for &lt;Invoice Date&gt; (End)" Prompt_Binding_Start_Name="WebiParam_enter_value_s__for__invoice_date___end__634569426773312776" Is_Start_Custom_Name="False" Prompt_Binding_End_Name="" Is_End_Custom_Name="Fal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | se" AddDefaultValueList="False" UpdateDefaultValueList="False"/></PromptBindings><DataSourceParameterValues/></Webi_document><Webi_document Connection_id="3" CUID="UnivCUID=Aefky07UDZFKiXBO2CcvyIk" Document_name="unvFleet_Analyst" CurrentReportDrillActive=
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "False" ReportPath="/Reporting" HasPrompt="0" HasQueryContext="False" bHasPromptToBind="True"><Container ContainerCUID="" ContainerKind="1"/><query_specification>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;QuerySpecification xmlns:[NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | rg/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" d1p1:SamplingMode="None" d1p1:SamplingSize="0" xmlns:d1p1="http://query.businessobjects.com/2007/06/01"&gt;  &lt;QueryBase xsi:type="Query" ID="Combined [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | usinessobjects.com/2005"&gt;    &lt;QueryResult Key="UnivCUID=Aefky07UDZFKiXBO2CcvyIk.DO7c"&gt;      &lt;Name&gt;Serial Nbr&lt;/Name&gt;    &lt;/QueryResult&gt;    &lt;QueryResult Key="UnivCUID=Aefky07UDZFKiXBO2CcvyIk.DOa0"&gt;      &lt;Name&gt;Extended Pr
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ice&lt;/Name&gt;    &lt;/QueryResult&gt;    &lt;QueryCondition QueryConditionOperator="And"&gt;      &lt;Item xsi:type="Filter" FilterOperator="InList"&gt;        &lt;FilteredObject Key="UnivCUID=Aefky07UDZFKiXBO2CcvyIk.DO85"&gt;          &lt;Name&gt;Custo
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mer Number&lt;/Name&gt;        &lt;/FilteredObject&gt;        &lt;Operand xsi:type="Values"&gt;          &lt;d1p1:NativeFreeValue xsi:type="xsd:string"&gt;71415901&lt;/d1p1:NativeFreeValue&gt;        &lt;/Operand&gt;      &lt;/Item&gt;      &lt;Item xsi:ty
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pe="Filter" FilterOperator="Between"&gt;        &lt;FilteredObject Key="UnivCUID=Aefky07UDZFKiXBO2CcvyIk.DO8d"&gt;          &lt;Name&gt;Invoice Date&lt;/Name&gt;        &lt;/FilteredObject&gt;        &lt;Operand xsi:type="Prompt" KeepLastValues="true" Cons
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | trained="false" HasLov="true" Order="0" d5p1:Optional="false" xmlns:d5p1="http://queryservice.dsws.businessobjects.com/2007/06/01"&gt;          &lt;Question&gt;Enter value(s) for &amp;lt;Invoice Date&amp;gt; (Start)&lt;/Question&gt;        &lt;/Operand&gt;
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | &lt;Operand xsi:type="Prompt" KeepLastValues="true" Constrained="false" HasLov="true" Order="1" d5p1:Optional="false" xmlns:d5p1="http://queryservice.dsws.businessobjects.com/2007/06/01"&gt;          &lt;Question&gt;Enter value(s) for &amp;lt;Invoi
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ce Date&amp;gt; (End)&lt;/Question&gt;        &lt;/Operand&gt;      &lt;/Item&gt;      &lt;Item xsi:type="Filter" FilterOperator="InList"&gt;        &lt;FilteredObject Key="UnivCUID=Aefky07UDZFKiXBO2CcvyIk.[NAME];          &lt;Name&gt;Folder Desc&lt;/Nam
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e&gt;        &lt;/FilteredObject&gt;        &lt;Operand xsi:type="Values"&gt;          &lt;d1p1:NativeFreeValue xsi:type="xsd:string"&gt;B/D Labor&lt;/d1p1:NativeFreeValue&gt;          &lt;d1p1:NativeFreeValue xsi:type="xsd:string"&gt;Breakdown&lt;/d1p1:Na
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | tiveFreeValue&gt;          &lt;d1p1:NativeFreeValue xsi:type="xsd:string"&gt;Ext Travel&lt;/d1p1:NativeFreeValue&gt;          &lt;d1p1:NativeFreeValue xsi:type="xsd:string"&gt;PF Job&lt;/d1p1:NativeFreeValue&gt;          &lt;d1p1:NativeFreeValue xsi:type="
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xsd:string"&gt;Repair Field&lt;/d1p1:NativeFreeValue&gt;          &lt;d1p1:NativeFreeValue xsi:type="xsd:string"&gt;Repair Shop&lt;/d1p1:NativeFreeValue&gt;          &lt;d1p1:NativeFreeValue xsi:type="xsd:string"&gt;Scheduled Maintenance&lt;/d1p1:NativeFre
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eValue&gt;        &lt;/Operand&gt;      &lt;/Item&gt;    &lt;/QueryCondition&gt;  &lt;/QueryBase&gt;  &lt;QueryProperty Name="DuplicatedRows" Activate="true" Value="false" xmlns="http://query.businessobjects.com/2005" /&gt;  &lt;QueryProperty Name="MaxFetc
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hedTime" Activate="true" Value="-1" xmlns="http://query.businessobjects.com/2005" /&gt;  &lt;QueryProperty Name="MaxRowFetched" Activate="true" Value="-1" xmlns="http://query.businessobjects.com/2005" /&gt;  &lt;QueryProperty Name="DuplicateRowAggregation"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Activate="false" Value="true" xmlns="http://query.businessobjects.com/2005" /&gt;&lt;/QuerySpecification&gt;</query_specification><Data_providers/><Original_data_providers/><prompts><prompt promptName="Enter value(s) for &lt;Invoice Date&gt; (Start)" prom
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ptID="ROOT.0" valueType="1" promptBindType="1" AllowMultipleValues="False" isOptional="False"><currentPromptValues><disreteValue type="2" value="2011-3-1T0:0:0" RowIndex=""/></currentPromptValues></prompt><prompt promptName="Enter value(s) for &lt;Invoice
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date&gt; (End)" promptID="ROOT.1" valueType="1" promptBindType="1" AllowMultipleValues="False" isOptional="False"><currentPromptValues><disreteValue type="2" value="2011-3-31T0:0:0" RowIndex=""/></currentPromptValues></prompt></prompts><QueryContexts/><Web
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | iViews><WebiView view_id="1" refresh_order="-1" part_UREF="" part_type="0" Conceal_data_when_saving="False" Keep_user_format="True" Instance_by_user="False" Username="" Logon_User_Instance="False" Refresh_DB="True" Use_Report_Saved_Data="False" Use_specifi
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c_instance="False" specific_instance_cuid="" specific_instance_description="" Need_format="False" Custom_view_name="unvFleet_Analyst document (2)" Last_refresh_status="1" Last_refresh_description="" Last_refresh_time="2011-11-16T13:35:18" Last_refresh_time
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | _taken="11609"><Regions><Region name="HHeading" DataRowCount="1" DataColCount="2"><LayoutManager LinkRows="False" LinkCols="False" Version="1.0" RegionName="HHeading"><CustomRows Axis="Row"/><CustomColumns Axis="Column"/></LayoutManager></Region><Region na
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | me="DataGrid" DataRowCount="7" DataColCount="2"><LayoutManager LinkRows="False" LinkCols="True" Version="1.0" RegionName="DataGrid"><CustomRows Axis="Row"/><CustomColumns Axis="Column"/></LayoutManager></Region></Regions></WebiView></WebiViews><PromptBindi
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ngs><PromptBinding Prompt_Binding_Name="Enter value(s) for &lt;Invoice Date&gt; (Start)" Prompt_Binding_Start_Name="WebiParam_enter_value_s__for__invoice_date___start__634569426483234384" Is_Start_Custom_Name="False" Prompt_Binding_End_Name="" Is_End_Custo
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m_Name="False" AddDefaultValueList="False" UpdateDefaultValueList="False"/><PromptBinding Prompt_Binding_Name="Enter value(s) for &lt;Invoice Date&gt; (End)" Prompt_Binding_Start_Name="WebiParam_enter_value_s__for__invoice_date___end__634569426552397316" I
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s_Start_Custom_Name="False" Prompt_Binding_End_Name="" Is_End_Custom_Name="False" AddDefaultValueList="False" UpdateDefaultValueList="False"/></PromptBindings><DataSourceParameterValues/></Webi_document></Webi_documents></AddinModuleData></CrystalAddin>