Menu
I have a tablix in SQL REPORTS (SSRS) that has many grouped items.
It fits roughly 3.5 groupped item per page when printnig, however I dont want the groups to be split up over the 2 pages, I want a pagebreak to happen whenever the group needs to be split.
I dont want to have it 1 group per page either, I know there is an option for that.
623
To delete a page break, select the column to the right of the page break and choose Insert > Remove Page break — or use one of the following methods to resize a column in the Report Designer. Click the column header letter button of the column to change to column mode, and then choose Format > Column > Width.
To merge a block of cells, merge the cells horizontally first. After all cells have been merged into a single cell in each row, select adjacent cells (you can select all adjacent cells in a column) and merge them. In the tablix body area, cells can only be merged horizontally.
The keep together property attempts to keep individual rows on the same page, not all the rows. i.e, if you have a detailed row that is filled with content spanning multiple lines, that will still be kept together in the same page when possible.
Make a new report that will become your main report. Then, in the body of the main report instead of inserting a table or a textbox you can insert a subreport. Insert three subreports and then go into the properties of each to link them to each report you want to include in the main report.
At the bottom of the report builder, you will see two boxes, Row Groups and Column Groups. Select the Column Groups drop down, click "Advanced Mode" and then in Row groups highlight "Details". In Properties under the "Other" section, select "True" for Keep Together. and save. This should work. Note: I know this is old hope this helps people starting out though.
151
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
