Export to PDF & Excel
Last updated
Last updated
Inforiver allows you to export the table/matrix as either PDF or Excel. The industry-leading export capability delivers the following:
Export with formatting, category/value structure and notes
Export table/matrix along with scaled number formatting
Export calculated rows, columns, and edited cells
End-users in the reading view can customize export options
Export to Excel with expand/collapse capability
Export to multiple Excel worksheets based on category values
Pagination & page-break support for Export to PDF
You can find the export option under the 'Export' tab of the toolbar. There are two sections: 'Export to PDF' & 'Export to Excel'. Let's take a look one by one.
Export to PDF/Excel is supported only in Power BI Service.
The first step in exporting as a PDF file is configuring the page setup.
The page setup section provides options to customize the page size, orientation, margin etc. Click 'Page Setup', and a window opens as shown.
a) When the number of rows/columns doesn't fit on a single page, you can define the order in which the rows/columns are exported using the 'Content order' option.
Let's consider the below example. Based on the page scaling, only 8 columns and 20 rows can be accommodated on a single page.
When the 'Row first' option is chosen, the remaining rows for the first 8 columns are displayed on the second page. The third and fourth-page contents are highlighted in the image.
When the 'Column first' option is chosen, the remaining columns for the first 20 rows are displayed on the second page. The third and fourth-page contents are highlighted in the image.
b) Select the 'Page size' from the drop-down - Available sizes are Letter, A3, A4, A5. Tabloid and Legal.
c) You can select either Landscape or Portrait as page 'Orientation'.
d) You can scale the page manually by percentages or automatically scale to fit all columns in a single page using the 'Scaling' option.
e) You can apply a Narrow, Normal or Wide 'Margin' as per the requirement.
f) You can select 'Font' style from the available options in the dropdown. Custom fonts can also be used when exporting.
If the data is customized with different fonts, the font chosen in the Settings panel is used for PDF export.
g) You can 'Show header and footer' either only on the First Page or on Every Page
h) You can create a cover page for your report by First page image toggle. Select a custom image to use as the cover page.
i) If you want the image to fill the entire cover page, select the Use as background image checkbox.
j) You can capture comments and replies in the fully formatted PDF exports. Check the 'Include comment replies' to export the replies in the comments column.
After exporting the report to a PDF, you will be able to see formatted comments and replies in the file.
k)You can select the 'Include footnotes' option to export the footnotes along with the table/matrix
l) You can set the 'Footnote position' as
Last Page: Footnotes get printed on the last page.
Dynamic: Based on the available space, footnotes get printed either on the same page where they are added or on the last page.
m) Click on 'Update' to save your page setup selection. Click on 'Reset' to reset all your selections.
Once the page setup is complete, you need to choose whether the entire matrix needs to be exported or just selected columns.
a) You can export all the rows and columns by clicking 'Entire Matrix'. Click on 'PDF Report' to export the file in PDF format.
c) A pop-up appears as shown. The PDF file can be either saved to the computer or it can be sent by email. To save the document, choose 'Save to Computer', and click on the 'Click to export' option.
e) A pop-up appears showing a warning, click 'Download'.
f) The entire matrix gets exported as shown.
If you need to export only selected columns of your report, click 'Selected Columns' as highlighted in the below image.
The selected columns 'Quarter, Q1, Q2' are downloaded as shown.
Export to PDF does not support image columns.
You can export your report as an Excel file by clicking on the 'Export report' dropdown as shown in the below image.
When there are row/column hierarchies, there are three ways to export: 'Fully Expanded', 'With Expand/Collapse', and 'Current State'.
Note that 'Page setup' is not applicable for export to Excel.
Let's look at the three options one by one.
You can export the visual with all rows fully expanded by choosing the 'Fully Expanded' option. In the Inforiver visual, you can see that 'East' and Pacific -> Beverages are collapsed.
In the exported Excel, you can see that 'East' and Pacific -> Beverages are fully expanded.
To export as Excel with expand/collapse-enabled row hierarchies, select the 'With Expand/collapse' option.
The downloaded Excel shows the same expand/collapse state as in the report and also has the expand/collapse buttons.
Export to Excel retains the expand/collapse state only for row hierarchy and not for column hierarchy.
To export the current expand/collapse state without an option to expand/collapse in the Excel file, you can select the 'Current state' option.
The downloaded Excel shows the same expand/collapse state as in the report.
Export to Excel does not support images and charts. Only basic icons that are available in excel, rating, and data bars are supported.
You can copy the data from your Inforiver visual including the calculated row, columns, edits, and notes (if there are any). The copied data can be easily pasted into an Excel sheet.
The keyboard shortcut for the copy to clipboard option is 'Ctrl+C+L'
The above data has been copied and pasted in an Excel sheet and it gets displayed as shown in the below image.
Another way to share reports is by sending ad-hoc emails. To learn more, refer to Send to email.
