web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

How is the report displayed paging

(0) ShareShare
ReportReport
Posted on by 5

Hello, there is something wrong with the new report. There are 12 records in the data which should be displayed in 12 pages normally, but only one page is displayed at present, Header table only shows the first row of recorded data, while all the data of Line table are displayed in the same report.

0535.MicrosoftTeams_2D00_image.png

I have the same question (0)
  • Suggested answer
    Mohit Rampal Profile Picture
    12,565 Moderator on at

    Hi, You can create group on a Field and control records visibility per page. Please check this article

    www.techbrothersit.com/.../how-to-display-x-rows-per-page-in-ssrs.html

  • act salution Profile Picture
    5 on at

    Thanks for your answer.

    actual problem is: I want the report to be a Header data table showing one page for each record (plus the associated Line data table), but actually the Header has 12 records, the report only shows one page, the Header shows the first record, and the Line shows the corresponding record of the Header

    Thanks & regards,

    0167.pic20230423153216.png

  • Mohit Rampal Profile Picture
    12,565 Moderator on at

    Are you using page break option in the report. 

    How about creating groups and displaying relevant records in each page. It should create single page for each unique record.

    stackoverflow.com/.../in-ssrs-i-am-trying-to-create-a-ssrs-report-that-creates-a-new-page-per-row-of

    How come headers data is displaying in lines section. I can see two datasets, so something not right in report design.

  • act salution Profile Picture
    5 on at

    the design:

    0045.Pic202304231739171.png

    6675.Pic202304231739172.png

    8032.Pic202304231739173.png

    1300.Pic202304231739174.png

    the report run result:

    last page:

    7028.Pic202304231739175.png

    else pages:

    0564.Pic202304231739176.png

    The first impression is that the association between the Header table and the Line table is not established.

    thanks & regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 590 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 349

#3
Diego Mancassola Profile Picture

Diego Mancassola 263

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans