CREPORTPART

The CREPORTPART formula allows you to embed a section of another CALUMO report in your report and have it react dynamically with other dynamic elements on the report such as CCHART formula.  

Syntax

CREPORTPART(ReportName, Range, Family, Properties, Slicer1, …, SlicerN)

Arguments

ReportName

(Required) The public CALUMO report that you want to make a part out of

Range

(Required) The cell range or named range on the report that you want to embed

Family

(Required)

The chart family you want to connect this part to.

Properties

The additional properties to control how the part works. The CREPORTPARTPROPERTIES helper formula should be used here to feed in the properties.

Slicer1..n

The member unique id’s that you want to pass this report to drive its initial start state.

Notes

For this formula to work correctly with other interactive charts on the report, a CCHARTSELECTIONS formula with the same Family must be on your report as the CREPORTPART listens to this for member selections to react to.

A part is not a full blown representation of a CALUMO report, it is a cut down version that renders the same but has limitations in its functionality, e.g. it can not do writeback or cell navigation or freeze panes. If you want full CALUMO report functionality, then you need to look at using CREPORTFRAME.