Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / SSRS report printing o...
Finance forum
Suggested answer

SSRS report printing one row per page on Landscape

Posted on by 447
Good day folks,

I have a report that is printing one row per page instead of printing enough rows per page. It's having every row that's coming from the dataset on it's own page. I have created a SSRS Landascape report, added a header and rows, clicked Advanced Mode and on the Header row I have the below properties

pastedimage1667194099695v1.png

On the rows I have the below properties.

pastedimage1667194099697v2.png

Is there something I'm doing wrong here or something I'm missing?

  • GirishS Profile Picture
    GirishS 27,828 Moderator on at
    RE: SSRS report printing one row per page on Landscape

    You don't need to set the Advance mode properties - Just remove them and check.

    Also check -  on the Group by Properties >> Whether you have added any page break options.

    On the AccountNum >> Properties >> Page break options >>  Between each instance of group should be unchecked.

    Thanks,

    Girish S.

  • Suggested answer
    Huggins Mafigu Profile Picture
    Huggins Mafigu 447 on at
    RE: SSRS report printing one row per page on Landscape

    Hi Girish,

    Here it is

    pastedimage1667196024213v1.png

  • GirishS Profile Picture
    GirishS 27,828 Moderator on at
    RE: SSRS report printing one row per page on Landscape

    Also try removing the column header properties you already set on the Tablix member(Screenshot of the properties you posted above).

  • GirishS Profile Picture
    GirishS 27,828 Moderator on at
    RE: SSRS report printing one row per page on Landscape

    Does you have added group by on the report?

    Can you show us a screenshot of the report design along with group by?

    Thanks,

    Girish S.

  • Suggested answer
    Huggins Mafigu Profile Picture
    Huggins Mafigu 447 on at
    RE: SSRS report printing one row per page on Landscape

    Hi Girish,

    Thank you for your quick response.

    Yes my report is using a Tablix and the above properties are the only properties I have set.

    "Keep together on one page if possible" is set but the results remain the same.

  • Suggested answer
    GirishS Profile Picture
    GirishS 27,828 Moderator on at
    RE: SSRS report printing one row per page on Landscape

    Hi Huggins Mafigu ,

    Does your report has Tablix and group by?

    Try setting the below property and check.

    On the Tablix property >> General >> Page break options >> check the "Keep together on one page if possible".

    Thanks,

    Girish S.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,041 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans