Export to PDF & Excel
Last updated
Was this helpful?
Reporting & Writeback Matrix Docs
Last updated
Was this helpful?
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 or 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 ​
​Pagination & page-break support for Export to PDF
You can find the export option in the toolbar's 'Export' tab. There are two sections: 'Export to PDF' and 'Export to Excel'. Let's look at them one by one.
The first step in exporting as a PDF file is to configure the page setup.
The page setup section provides options to customize the content order, page size, orientation, margin, font, image/logo and comment settings, etc. Click on Page Setup. A side panel opens as shown.
Content Order: 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.
Page size: Select the 'Page size' from the drop-down - Available sizes are Letter, A3, A4, A5, Tabloid, and Legal.
Orientation: Select either Landscape or Portrait as page orientation.
Scaling: Scale the page manually by percentages or automatically scale to fit all columns in a single page using this option.
Margin: Apply a narrow, normal, or wide margin as per your requirement.
Font: Select a font style from the available options in the dropdown. Custom fonts can also be used when exporting.
Show header and footer: You can show the header and footer either only on the first page or on every page.
Add image/logo to the first page: You can create a cover page for your report using this toggle. Select a custom image to use as the cover page.
Use as background image: If you want the image to fill the entire cover page, select this checkbox.
Margin and alignment: The logo can also be aligned using the margin settings as well as the horizontal and vertical alignment options, instead of filling the entire cover page.
Include comment replies: 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.
Include comments in last page: In addition to displaying the comments on the respective pages, you can also choose to include all added comments (and replies, if enabled) on the last page of your exported PDF.
Include author name and date in comments: Select this option to include the comment authors' name, as well as the commented date and time.
Include Filter Info: When you select this checkbox, the exported PDF will include information about the filter contexts in the report.
Include footnotes: You can select this option to export the footnotes along with the table/matrix.
Include Global/Locale variable: Select this option to include global and local variables in the exported PDF.
Compress PDF: You can export PDFs with a maximum file size of 10 MB. This option allows you to compress your PDF export.
Decimal Precision: Set a custom decimal precision for the export.
Word Wrap: The 'Word Wrap' options are specifically intended for reports that are formatted using table functions.
The 'Precise' option enables word wrapping, ensuring that overflowing rows are wrapped onto the next line and fully visible in the PDF export. In contrast, the 'Auto' option does not apply word wrapping, which may result in truncated data. The highlighted text in the screenshots depicts the difference between Auto and Precise word wrapping.
Footnote position: 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.
Finally, click Update to save your page setup preferences, or click on 'Reset' to reset all your selections to defaults.
Once the page setup is complete, you need to choose whether the entire matrix needs to be exported or just selected columns.
You can export all the rows and columns by clicking Entire Matrix.
Click on PDF Report to export the file in PDF format.
A pop-up appears as shown. The PDF file can be either saved to the computer or sent by email. To save the document, choose Save to Computer and then click on the Click to export option.
Click Download to confirm.
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 image below.
The selected columns are downloaded as shown.
In the Page Setup menu, only the Excel Settings section is applicable for export to Excel.
Freeze Header: Select this check box to freeze the header in the exported Excel.
Freeze Label Column: Select this check box to freeze the column labels in the exported Excel.
Add appendix at last sheet: Select this checkbox to include the formula appendix at the end of the exported Excel report.
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'. You also have the option to customize header settings.
Let's look at the 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.
Select this option to export as Excel with expandable and collapsible row hierarchies.
The exported Excel displays the same expand/collapse state as in the report and includes the expand/collapse buttons.
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.
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 above data has been copied and pasted in an Excel sheet and it gets displayed as shown in the below image.
Excel Settings: These are the options available when exporting to Excel. They are explained .
Another way to share reports is by sending ad-hoc emails. To learn more, refer to .
