![what is ssrs report builder what is ssrs report builder](https://www.sharepointdiary.com/wp-content/uploads/2013/12/2-create-new-report-builder-report.png)
Open the main report and drag & drop the CoverPage report into the report header (to make a report header, just drag the data region down a bit the space above it is the report header). We’re ready to put it into the main report. Put everything you want on your cover page into the rectangle-textboxes for text, images, lines, even data regions if you need to.
![what is ssrs report builder what is ssrs report builder](https://docs.ifs.com/techdocs/Foundation1/040_administration/255_br_and_a/005_adhoc_reporting/040_SSRS_Reports/images/MyReportView.png)
Now you can position the rectangle, change its dimensions, and otherwise format it to look like the cover page you need. This will cause the rectangle to end in a page break, separating the cover page from the rest of the report. Open the rectangle’s properties window (right-click on the rectangle and select Rectangle Properties…) and select Add a page break after. In the same project containing the main report, create a new, blank report called CoverPage that has a single rectangle in it and nothing else. Actual steps may vary from the ones shown here, though they should be similar.įirst, we’ll create a report that will be the actual cover page when it is used as a subreport in the main report.
![what is ssrs report builder what is ssrs report builder](https://i.ytimg.com/vi/CE4ZfGKAeUM/maxresdefault.jpg)
I’m using SQL Server Data Tools 2010 (Visual Studio 2010 + MS BI Libraries) in this demonstration, but you can use Report Builder or other tools that create SSRS rdl files.
What is ssrs report builder how to#
The demonstration in this article will show you how to create a cover page using a subreport. The advantage of using a subreport is that the cover page doesn’t clutter your report and you don’t have to always negotiate your way around the cover page every time you want to edit your report. The rectangle can either go directly into the report header, or it can go into a subreport that in turn goes into the report header. Here’s how it works: Everything you want in your cover page will go into a rectangle that includes a page break after it to separate the cover page from the rest of the report (this ability to do page breaks is the reason we use a rectangle). The cover page usually doesn’t show any data or page numbers, and the first page of data usually displays as page 1.Ĭover pages can be made pretty easily in SSRS.
What is ssrs report builder professional#
It can add clarity to your report and give it a clean, professional look. A cover page is simply a page that comes before the report data and that usually contains a report title and other identifying information.