Pixel-perfect paginated reports in Power BI. Simplified.

1. Utilize First-previous-next-last navigation

Navigate between pages in the paginated report using the First-Previous-Next-Last navigation.

2. Insert a page break based on the row category

Provide breaks in your paginated report dynamically based on the row category values (e.g., each category in the rows starts on a new page). In the image below, by selecting ‘Manufacturer’ in the ‘Row Break’ dropdown, each page shows only the products belonging to a manufacturer.

3. Provide page breaks based on column categories

Start a new page in the paginated report based on the column category. In the image below, we have a column hierarchy (Quarter -> Month), and each quarter starts on a new page.

4. Insert a blank row after each category

Leverage section breaks to insert a blank row after each category. In the image below, a blank row is inserted after each category, i.e., Audio, Cameras and camcorders in the paginated report.

5. Apply pagination based on custom rows

Insert a page break at any point in the report by inserting a 'break row’ from ‘Insert’ -> ‘Insert Row.’ Choose the ‘Break rows’ option in the row break dropdown. The rows before and after the break row will be shown on different pages.

6. Use table and measure layouts

Apply tabular, matrix, and other Excel-like layouts to the paginated report. You can also display measures in rows or columns.

7. Excel-like report formatting

Apply Excel-like cell and value formatting to your paginated reports. You can change the font color, style, size, and text alignment in a cell or apply formatting effects. Inforiver also comes prepackaged with intelligent number formatting & scaling recognition capabilities.

8. Use charts inside tables

Deliver a variety of in-cell charts in your paginated reports in a few clicks. These include advanced bullet charts, waterfall charts, sparklines, range plots, and more.

9. Use one-click header and footer presets

​Leverage one-click presets to insert header and footer in your paginated reports. The header and footer can include highly formatted text, images, KPI cards, and charts.

10. Add KPI cards in the header and footer

Add KPI cards in the header and footer using one-click KPI card presets or customize them as desired.

11. Add charts in the header and footer

Insert a wide variety of charts in the header and footer; charts can be customized using the ‘Customize’ toolbar shown in the image below.

12. Create master-detail reports

Use Inforiver’s advanced, no-code paginated reporting feature – Report+, to create master-detail reports.

13. Create side-by-side comparison reports

Compare regions or categories side-by-side in a single click using the comparison view in Report+ module.

14. Create variance reports comparing two time periods

Create paginated reports with categorical data side-by-side across two periods, such as MoM comparison or month vs. YTD comparison, in a single click using IBCS templates.

15. View a summary of the categories

Use the summary layout to view a summary of the categories and the measures in your paginated report.

16. Perform paginated export to Excel

Export each page in a paginated report to a different worksheet in Excel, along with cell and value formatting, charts, conditional formatting, notes, etc.

17. Filter content by recipients when scheduling reports

Filter records based on specific category values and schedule paginated reports to particular users (e.g., Send US records to the US Regional Head, EMEA records to the EMEA Regional Manager, etc.).

Sample paginated reports

Check out some of the examples of formatted paginated statements delivered by Inforiver.

1. Regional sales report

This report displays the monthly sales and profit trends and sub-category level values based on year selection in the dropdown on the top left.

2. Sales analysis report

In this report, the header uses charts and KPI cards. Images and text content can also be added from the ‘Design’ tab -> ‘Header & Footer’ option.

3. Country sales performance

The monthly sales and sales quota are compared using bullet charts. Calculated columns are inserted to show the sales contribution.

4. Invoice

This example shows a highly formatted invoice with multi-line headers, text, and dropdown data input columns.

5. Split view comparison

This report compares several product categories using the ‘Comparison’ view in ‘Report+’. The selections can be changed using the dropdowns in the top menu.

6. Side-by-side comparison report

In this report, the number of medals achieved by male and female contestants for each sport are shown side by side. The top N filter has been applied to show only the top 10 sports based on medals.