Multi-sheet Web Printing

Revision as of 12:52, 4 July 2018 by CFrance (talk | contribs)

From Version 8, web reports can be configured to enable multi-selection printing or save to Excel. This allows you to generate a single PDF or static Excel workbook containing one page per slicer combination as configured within the report.

This is useful, for example, to print the same report for different months or regions.


Enabling Multi-Sheet Printing

Multi-sheeting must first be enabled within Workbook Options.


Toggle the check boxes to enable/disbale multi sheet printing (allows creation of a multi-sheet pdf) and/or save to Excel multi sheet which saves a static version of the workbook.

The custom multi sheet caption allows a custom title for the print dialog which will be shown in the published Web report. If this is not set, the additional print option is called 'multi-sheet print' (see below).

Specify the worksheet(s) to be propagated and the slicers which will be used for making print selections.


After enabling multi-sheet printing, publish the workbook as normal.

Multi-Sheet Printing a Web Report

Open the report in XLCubed Web and select the print icon. Select "Multi-sheet print" (or the custom caption as defined in Workbook Options).

You will then be able to see the available slicers from which you acn make the relevant selections.


A PDF file will be created with one page for each slicer combination. Save to Excel creates a workbook in the same way.