| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Multi-sheet Web Printing"
| Line 2: | Line 2: | ||
| − | [[image: | + | [[image:msp1.png|350px|centre]] |
| Line 9: | Line 9: | ||
| − | [[image: | + | [[image:msp2.png|350px|centre]] |
My multi-sheet web printing options are: | My multi-sheet web printing options are: | ||
| − | [[image: | + | [[image:msp3.png|350px|centre]] |
| Line 23: | Line 23: | ||
| − | [[image: | + | [[image:msp4.png|350px|centre]] |
| Line 30: | Line 30: | ||
| − | [[image: | + | [[image:msp5.png|350px|centre]] |
A PDF file will be created with one page for each slicer selection. Save to Excel creates a workbook in the same way. | A PDF file will be created with one page for each slicer selection. Save to Excel creates a workbook in the same way. | ||
Revision as of 09:29, 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 single 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(s) that should be propagated and the slicers which should be used.
Here is 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.
