How to Use Page Breaks Effectively: SQL Server


show more Reports generated by Report Builder in your SQL Server are generally viewed as web pages, but web pages scroll with a screen instead of having individual pages. Checking reports in Print Layout lets you see how the printed document will appear because it inserts page breaks. This online video guides you through the process of using page breaks effectively. show less
please wait ...

Using page breaks

It's always worth bearing in mind that the Report Builder layout is not strictly WYSIWYG; it's not what you see is what you get--it can't be. You don't know what you're going to get until this runs. Now I've created a simple report with one table on it that's showing products grouped together into categories. Nothing magical here, but if I take a look at it, it looks like product name is a little too small. We could do with dragging that a little bit wider. So I'm going to go back into Design view and start to move this out, give myself a bit more room. See, because the assumption is that the most common way to view these reports is on the web, it will happily expand left or right and up to down as much as you need to.

So if I drag this out and keep dragging it out this way and then select this column, give myself a bit more room, if we go ahead and run it, it looks pretty good here. But if I view the print version of this, jumping over to Print Layout--I d...

Using page breaks
Video duration: 5m 37s 3h 44m Advanced

Viewers:

Reports generated by Report Builder in your SQL Server are generally viewed as web pages, but web pages scroll with a screen instead of having individual pages. Checking reports in Print Layout lets you see how the printed document will appear because it inserts page breaks. This online video guides you through the process of using page breaks effectively.

Subjects:
Developer IT
Software:
SQL Server
Author:
please wait ...