Multi-sheet Web Printing

Revision as of 08:18, 25 September 2014 by Gcrawford (talk)

With v8, web reports can be configured to enable multi-selection printing or save to Excel. For example if a published report has a slicer allowing the user to select a region (North / East / South / West), and another to choose the value (Gross Revenue / Unit Sales), the user can now quickly generate a single pdf or static Excel workbook containing their required selection combinations between the two slicers. This is enabled within workbook options:


Ms1.png


You need to specify the worksheet(s) that should be propagated and the slicers which should be used. Here is a simple grid with a slicer on Measures:


Ms2.png


My multi-sheet web printing options are:

Ms3.png


Enable the multi sheet printing and/or save to Excel multi sheet - this saves a fixed version of the workbook. The custom multi sheet caption allows the user to enter a more meaningful title (see below). Also specify the worksheet that is to be propagated along with the slicers to use. Publish the workbook as normal – when running in Web if the user chooses the option to Print they will be presented with the additional multi-select option:


Ms4.png


The user can then select slicer choices:


Ms5.png


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