Need Help with custom XML code

[avenluiss]

Hello, can someone please help me with this XML code?
Attached is what the report looks like. I need help removing the waterfall subtotal, remove subtotal in rows 3 and 4. Fill down columns 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:

Code: Select all

<?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[url=https://omegle.site/][color=#000000].[/color][/url]</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>

Hope some answers me. Thanks for it in advance.

Regards
Luis

[Radu]

Hi Luis,

If you want to process the XML document and make changes to it, maybe you can try to create an XSLT styleshet, Oxygen XML can apply an XSLT stylesheet on an XML document.
https://www.oxygenxml.com/doc/versions/ ... -xslt.html

Also resources about learning XSLT:
https://blog.oxygenxml.com/xslt_training.html

Regards,
Radu