Help with XML code to fill down blank cells
Questions about XML that are not covered by the other forums should go here.
-
- Posts: 1
- Joined: Wed Jul 25, 2018 5:17 pm
Help with XML code to fill down blank cells
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>
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>
Return to “General XML Questions”
Jump to
- Oxygen XML Editor/Author/Developer
- ↳ Feature Request
- ↳ Common Problems
- ↳ DITA (Editing and Publishing DITA Content)
- ↳ SDK-API, Frameworks - Document Types
- ↳ DocBook
- ↳ TEI
- ↳ XHTML
- ↳ Other Issues
- Oxygen XML Web Author
- ↳ Feature Request
- ↳ Common Problems
- Oxygen Content Fusion
- ↳ Feature Request
- ↳ Common Problems
- Oxygen JSON Editor
- ↳ Feature Request
- ↳ Common Problems
- Oxygen PDF Chemistry
- ↳ Feature Request
- ↳ Common Problems
- Oxygen Feedback
- ↳ Feature Request
- ↳ Common Problems
- Oxygen XML WebHelp
- ↳ Feature Request
- ↳ Common Problems
- XML
- ↳ General XML Questions
- ↳ XSLT and FOP
- ↳ XML Schemas
- ↳ XQuery
- NVDL
- ↳ General NVDL Issues
- ↳ oNVDL Related Issues
- XML Services Market
- ↳ Offer a Service