News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... In SSRS, I need to dis...

Microsoft Dynamics 365 | Integration, Dataverse...

Suggested answer

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

(3) Share

Report

Report

Posted on by CU19091253-0

6

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.

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Komi Siabi 12,711 Most Valuable Professional on at

Like (0)

Report

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 7,369 Super User 2024 Season 2 on at

Like (0)

Report

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

Are you talking about D365FO?

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,419 Super User 2024 Season 2

#2

Martin Dráb 230,492 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans