Skip to content

CREPORTFRAME

CREPORTFRAME only applies to published reports on the web. In Excel the text “CReportFrame” is returned.

The function creates an in-line frame in that displays the URL.

The URL can link to a published report or a web page. The web page inside the frame is displayed from the top left down.

The rendered CREPORTFRAME will be the width of the cell (or merged cells) containing the CREPORTFRAME at the time of publish.

The height is determined by the height argument.

This formula is not supported when sending a report to PDF

Syntax

CREPORTFRAME (URL, Name, Scrollable, Height, Style, Arg1…Arg20)

Arguments

URL

(Required)

The url of the page to be called into the body of the in-line frame (iFrame)

Name

The name given to the iFrame on the report. This name can be used in conjunction with CHYPERLINK to target a CREPORTFRAME for update without refreshing the entire contents of the page on which the CREPORTFRAME resides.

Scrollable

Determines if scroll bars will appear in the CREPORTFRAME where the called URL exceeds the size of the iFrame. Valid entries values are “Yes” or “No” or “Auto”

Deafult value: yes

Height

The height of the frame in percent of the size of the cell (or merged cells) containing the CREPORTFRAME at the time of publish (%), pixels (px), points (pt). For example 100px = 100 pixels.

Default value: 100%

Style

Any addition css styling you want to add to your iframe

Arg1…Arg20

URL arguments or Member Unique ID’s of dimension slicers. For example, this could hide the toolbar in reports by setting Arg1 to “ht=true”

Usage Scenarios

To call a report, or part of a report into the body of another report. This is useful to combine reports into linked or guided analytics, or incorporate other pages available from the web.  When called from a menu page, the CREPORTFRAME can provide a live preview of a called report.

While input of URL value is compulsory, all other arguments are optional.

Examples

The CREPORTFRAME formula is in cell C14, and in this instance, includes the CALUMO toolbar. The URL is from an existing published report, which is easily found by clicking on URL of the tab

On publishing, the following page is presented:

You will notice the CALUMO toolbar is present in the original page, together with the frame report.

To hide the toolbar in the frame report, we include the command ?ht=true at the end of the URL or set just “ht=true” as Arg1 (or any Argx)

The new URL line will now read https://cloud.calumo.com/calumo/api.mvc/reports/Margin%20Avg?ht=true

Now when publishing, the following is displayed:

It is possible to have more than one frame per page. The following report is made up from 5 individual reports. In Excel, it looks like:

Report frames have been highlighted in black to help identify the width of the report. Reports to be used are in column B, with the corresponding heights specified in column J. In all CALUMO report instances, the toolbar has been hidden (through the inclusion of ?ht=true). When published, the report displays as:

You will note even though differing height have been specified, the border illustrates the largest height for the row. Report 2 is placed as expected, but report 4 is at the foot of the frame. To bring to top for report 4, in Excel adjust the cell alignment to the top of the cell:

On republishing we observe:

Report 4 has now moved to the top of the frame. If we were to remove borders in Excel and republish we would obtain the required layout.

Altering our layout to the following and publishing:

We can obtain any layout we require: