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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / SSRS report printing o...
Finance | Project Operations, Human Resources, ...
Suggested answer

SSRS report printing one row per page on Landscape

(0) ShareShare
ReportReport
Posted on by Huggins Mafigu 484
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?

I have the same question (0)
  • Suggested answer
    GirishS Profile Picture
    GirishS 27,825 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.

  • Suggested answer
    Huggins Mafigu Profile Picture
    Huggins Mafigu 484 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.

  • GirishS Profile Picture
    GirishS 27,825 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.

  • GirishS Profile Picture
    GirishS 27,825 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).

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

    Hi Girish,

    Here it is

    pastedimage1667196024213v1.png

  • GirishS Profile Picture
    GirishS 27,825 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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,922

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,922

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 835 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans