From the course: SQL Server: Reporting Services
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Insert page breaks - SQL Server Tutorial
From the course: SQL Server: Reporting Services
Insert page breaks
- [Voiceover] In a printed report, you have no way of predicting how many records a report will display and how much will actually fit on the page. Usually the report will render to fit as many records on the page as it can, and then it'll just start again at the top of the next page. Controlling where your page breaks occur can be a bit of a challenge in a report layout that, by definition, needs to be flexible. With that said, there are three places that we can add page breaks into the design of our reports. You can use these to see if you can impose your own sense of structure on printed output. The first is on a data region or a table. Select a tablix object and then over in the properties sheet you can open up the properties for the tablix. Here we have page break options where we can add a page break before or add a page break after. But these options only affect the entire table, so you'll have a page break before the table, or after the entire table. It won't help us control…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.