All geek questions in one place

SSRS Stop group in a table divided between print pages

I have a table in SQL REPORTS (SSRS) that contains many grouped items.

It fits approximately 3.5 group elements per page when printing, however I do not want the groups to be divided into 2 pages, I want page breaks to occur whenever the group should be divided.

I do not want to have it 1 group per page, I know that there is an option for this.

+6
source share
3 answers

Probably the best place to start is the KeepTogether property at the group level.

enter image description here

Specifies whether to save all sections of the data area together on one page.

+1
source

At the bottom of the report builder, you will see two fields: row groups and column groups. Select the drop-down column groups, click Advanced Mode, and then select Details in the row groups. In the Properties section of the Other section, select True for Keep Together. and save. That should work. Note. I know this is a long-standing hope that it helps people get started, though.

+1
source

I just worked out three similar reports that all suffered from this problem.

Only after I selected the group line AND the details line to get a report to force a page break and keep the pages together.

Interestingly, I can set DETAIL BACK to false, and the report still functions correctly. I have no explanation why, but this is repeatable.

I am using SQL Server 2016 Report Builder (red)

0
source

Source: https://habr.com/ru/post/946056/

More articles:


All Articles