Page 1 of 1

Help with XML code to fill down blank cells

Posted: Wed Jul 25, 2018 5:21 pm
by johnt7748
Hello, can you someone please help me with this XML code?
Attached is what the report looks like. I need help removing the waterfall subtotal, remove the subtotal in row 3 and 4. Fill down column A and B. Is that possible? Thank you in advance!

https://imageshack.com/a/img921/4907/1BybuM.jpg


Here's the current report definition in the tool:

<?xml version="1.0" encoding="utf-16"?>
<SettingData Version="1">
<Settings>
<Property Name="AggregationResults" DataType="ArrayList" ReadOnly="0">ALL</Property>
<Property Name="ApplyCellFormat" DataType="Boolean" ReadOnly="0">0</Property>
<Property Name="ApplyThresholdFilter" DataType="Boolean" ReadOnly="0">0</Property>
<Property Name="CalculateFTEFromCalendar" DataType="Boolean" ReadOnly="0">0</Property>
<Property Name="CalendarPeriods" DataType="ArrayList" ReadOnly="0"></Property>
<Property Name="CalendarSet" DataType="String" ReadOnly="0" xml:space="preserve">18</Property>
<Property Name="CellFormatCurrencyPattern" DataType="String" ReadOnly="0"></Property>
<Property Name="CellFormatDatePattern" DataType="String" ReadOnly="0"></Property>
<Property Name="CostSets" DataType="ArrayList" ReadOnly="0">BCWS,BCWP,ACWP,EAC,ORIGBAC,ORIGEAC</Property>
<Property Name="CreateBlankNotes" DataType="Boolean" ReadOnly="0">0</Property>
<Property Name="CriteriaCollection" DataType="List[ReportCriterion]" ReadOnly="0">
<Item DataType="ReportCriterion">
<Property Name="Fields" DataType="ArrayList" ReadOnly="0"></Property>
<Property Name="Id" DataType="String" ReadOnly="0" xml:space="preserve">CA2</Property>
<Property Name="Level" DataType="Int32" ReadOnly="0">0</Property>
<Property Name="NewPage" DataType="Boolean" ReadOnly="0">0</Property>
<Property Name="Subtotal" DataType="Boolean" ReadOnly="0">1</Property>
</Item>
<Item DataType="ReportCriterion">
<Property Name="Fields" DataType="ArrayList" ReadOnly="0"></Property>
<Property Name="Id" DataType="String" ReadOnly="0" xml:space="preserve">CA3</Property>
<Property Name="Level" DataType="Int32" ReadOnly="0">0</Property>
<Property Name="NewPage" DataType="Boolean" ReadOnly="0">0</Property>
<Property Name="Subtotal" DataType="Boolean" ReadOnly="0">1</Property>
</Item>
<Item DataType="ReportCriterion">
<Property Name="Fields" DataType="ArrayList" ReadOnly="0"></Property>
<Property Name="Id" DataType="String" ReadOnly="0" xml:space="preserve">WP</Property>
<Property Name="Level" DataType="Int32" ReadOnly="0">0</Property>
<Property Name="NewPage" DataType="Boolean" ReadOnly="0">0</Property>
<Property Name="Subtotal" DataType="Boolean" ReadOnly="0">1</Property>
</Item>
</Property>
<Property Name="DisplayDataWorksheets" DataType="Int32" ReadOnly="0">1</Property>
<Property Name="DisplayDataWorksheetsCriteriaDescription" DataType="Boolean" ReadOnly="0">0</Property>
<Property Name="DisplayReportOptions" DataType="Boolean" ReadOnly="0">1</Property>
<Property Name="ExcludeIPMRFormat2SummaryFromBody" DataType="ArrayList" ReadOnly="0"></Property>
<Property Name="ExcludeSortCodesFromBody" DataType="ArrayList" ReadOnly="0"></Property>
<Property Name="FirstCalendarPeriodCumulative" DataType="Boolean" ReadOnly="0">1</Property>
<Property Name="HighlightVariances" DataType="Boolean" ReadOnly="0">0</Property>
<Property Name="IncludeIPMRFormat2SummaryInBottomLine" DataType="ArrayList" ReadOnly="0"></Property>
<Property Name="IncludeHistoryCostSets" DataType="Boolean" ReadOnly="0">0</Property>
<Property Name="IncludeNarrativeCategories" DataType="ArrayList" ReadOnly="0"></Property>
<Property Name="IncludeNoteCategories" DataType="ArrayList" ReadOnly="0"></Property>
<Property Name="IncludeOnlyNonZeroCostSets" DataType="Boolean" ReadOnly="0">0</Property>
<Property Name="IncludeOnlyNonZeroPeriods" DataType="Boolean" ReadOnly="0">0</Property>
<Property Name="IncludeOnlyNonZeroResults" DataType="Boolean" ReadOnly="0">0</Property>
<Property Name="IncludeSortCode" DataType="Boolean" ReadOnly="0">0</Property>
<Property Name="IsIPMR" DataType="Boolean" ReadOnly="0">0</Property>
<Property Name="ReportWizardParameters" DataType="ReportWizardParameters" ReadOnly="0">
<Property Name="AllowSelectCalendarSet" DataType="Boolean" ReadOnly="0">0</Property>
<Property Name="AllowSelectCostSets" DataType="Boolean" ReadOnly="0">1</Property>
<Property Name="AllowSelectCriteria" DataType="Boolean" ReadOnly="0">1</Property>
<Property Name="AllowSelectFilter" DataType="Boolean" ReadOnly="0">1</Property>
<Property Name="AllowSelectResults" DataType="Boolean" ReadOnly="0">1</Property>
<Property Name="AllowSelectSort" DataType="Boolean" ReadOnly="0">1</Property>
<Property Name="AllowSelectIPMRFormat2Summary" DataType="Boolean" ReadOnly="0">0</Property>
<Property Name="MaxNumberOfCostSets" DataType="Int32" ReadOnly="0">15</Property>
<Property Name="MaxNumberOfCriteria" DataType="Int32" ReadOnly="0">5</Property>
<Property Name="MinNumberOfCostSets" DataType="Int32" ReadOnly="0">1</Property>
<Property Name="MinNumberOfCriteria" DataType="Int32" ReadOnly="0">1</Property>
</Property>
<Property Name="Results" DataType="ArrayList" ReadOnly="0"></Property>
<Property Name="RollupResults" DataType="Boolean" ReadOnly="0">0</Property>
<Property Name="ScaleFactor" DataType="Int32" ReadOnly="0">1</Property>
<Property Name="ScaleFactorCaption" DataType="String" ReadOnly="0" xml:space="preserve">Dollars</Property>
<Property Name="SortLogTransactionsByTransactionDate" DataType="Boolean" ReadOnly="0">0</Property>
<Property Name="TemplateFile" DataType="String" ReadOnly="0" xml:space="preserve">PCS no GRP.xlsx</Property>
<Property Name="ThresholdFilterCompareType" DataType="String" ReadOnly="0" xml:space="preserve">OR</Property>
<Property Name="UseSelectedCalendarPeriods" DataType="Boolean" ReadOnly="0">0</Property>
</Settings>
</SettingData>