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 : boolean¶
Show slice buttons in a Published Report.
Default value: true
SliceFullWorkbook : boolean¶
Specify whether the entire Excel workbook is downloaded (true) or just the worksheet (false) when slicing a Published Report.
Default value: false
EnableMobileWriteback : boolean¶
Specify whether writeback is enabled in a Published Report only for mobile devices.
Default value: false
DisableAllDataWriteback : boolean¶
Specify whether writeback is enabled in a Published Report.
Default value: false
OnlySliceAsValues : boolean¶
Specify 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:
