Paginated Report - Print Layout not displaying all pages

[TrevorSeymour]

Hi folks,

Similar to this issue, but the opposite:

Solved: Paginated Report not showing all records in Web la... - Microsoft Fabric Community

My report is showing all records in the web layout view, but only 1 page (of 166) in the Print Layout view.  I've clicked Disable Preview Features but to no avail.

[TrevorSeymour]

Option 2 worked.  Thank you very much for your help!

[TrevorSeymour]

Hi Dengliang, 

In Web Layout, it says there are are total of 4 pages.  When I go to Print Layout, it only generates 1 page, but suggests theat there are 166.  And in Print Layout, I'm also unable to navigate around those pages.

[Anonymous]

Hi @TrevorSeymour ,

In my tests, both Web Layout View and Print Layout View can only see one page of records.

Therefore, do you mean that you see 166 pages of records in one Page in Web Layout View?
Or do you mean that you can see 166 records in one Page in Web Layout View and only one record in Print Layout View?

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TrevorSeymour]

Web Layout view shows 1 page of 4.  I can navigate through those pages by returning back to the Home tab, so that's fine.

In Print Layout view, it then says Total Pages 166, but only shows 1 very small page, with 10 records.  And no way to navigate through them.  Wondering if it's just meant to act as a preview page?

[Anonymous · Accepted solution]

Hi @TrevorSeymour ,

Add a Text Box in the lower left corner of the Report Builder, and then drag and drop the /Over All Pages/ built-in field into it, so that you will see /Total Pages 166/.

Only 10 records per row are displayed in Print Layout View, this may be because:
1. The row height is too high and the height per page is fixed, resulting in very few records being displayed.

2. The height of each page is too low, resulting in few records being displayed.

Once you have selected Print Layout View, click the /Home/ button in the upper left corner and you can then navigate these records.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.