Help with XML code to fill down blank cells
Questions about XML that are not covered by the other forums should go here.
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