Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum
Suggested answer

In SSRS, I need to display only one record on each page

Posted on by 4

In SSRS, I need to display only one record on each page, with the next record appearing on the second page, and so on. Currently, I have two tables, two text boxes, and one matrix per page. I've tried rows grouping, but it's affected the first table only, and it's sending other table(s), mtrixes, and text boxes on the next page too.

 

My dataset, "MsDset," is fetching 60 records.

  • Suggested answer
    Komi Siabi Profile Picture
    Komi Siabi 12,606 Most Valuable Professional on at
    In SSRS, I need to display only one record on each page
    Ensure you, you put all of these component inside a Tablix. 
    On the Tablix property go to General -> Page break option and check Keep together on one page.
  • Layan Jwei Profile Picture
    Layan Jwei 7,071 Super User 2024 Season 2 on at
    In SSRS, I need to display only one record on each page
    Are you talking about D365FO?

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans