Skip to content

CREPORTPROPERTIES

The CREPORTPROPERTIES formula has no effect in Excel but is used to control a Published Report, and how Send To Excel works and what writeback options are available.

The ShowSliceButton argument allows a report builder to disable the use of Send To Excel for their Published Reports.

The SliceFullWorkbook argument allows a report builder to allow users to access the entire published workbook, instead of just the single Worksheet from which the web page is generated.

The formula can be placed in any cell on the spreadsheet.

Syntax

CREPORTPROPERTIES (ShowSliceButton, SliceFullWorkbook, EnableMobileWriteback, DisableAllDataWriteback, OnlySliceAsValues)

Arguments

ShowSliceButton

Show slice buttons in a Published Report

Default value: true

SliceFullWorkbook

When slicing on a Published Report, whether the entire Excel workbook is downloaded (False results in just the sheet the report was on being downloaded)

Default value: false

EnableMobileWriteback

Whether writeback is enabled in a Published Report for just mobile devices

Default value: false

DisableAllDataWriteback

Whether writeback is enabled in a Published Report.

Default value: false

OnlySliceAsValues

Whether this report will only allow the user to slice as values when using Send To Excel

Default value: false

Usage Scenarios

A report builder can use the ShowSliceButton argument to disable the use of Send To Excel for their Published Report, by setting the argument to FALSE. A user will not be able to download and view the Excel file which generated the web page.

The SliceFullWorkbook argument allows the user to access to the entire workbook that was published, instead of just the single sheet published when set to TRUE

Setting EnableMobileWriteback to TRUE will enable writeback on mobile devices.

Examples

When the formula is set to

=CREPORTPROPERTIES(False, False, True)

The following CALUMO web toolbar is presented: 

 

When the formula is set to

=CREPORTPROPERTIES(True, False, True)

The following CALUMO web toolbar is presented with the Send to Excel button showing.