Difference between revisions of "Multi-sheet Web Printing"
(Clarify pdf output)
|Line 1:||Line 1:|
v8a to and to Excel . This is enabled within workbook options:
Revision as of 09:16, 25 September 2014
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 pdf or static Excel workbook containing their required selection combinations between the two slicers. This is enabled within workbook options:
You need to specify the worksheet that should be propagated and the slicers that should be used. Here’s a simple grid with a slicer on Measures:
My multi-sheet web printing options are:
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:
The user can then select slicer choices:
A PDF file will be created with one page for each slicer selection. Save to Excel creates a workbook in the same way.