![]() From the Cover Page drop-down menu select Remove Current Cover Page.Click Insert > Cover Page from the Ribbon.If you have created a cover page in Word and decide later that you wish to remove it, you do not have to delete the elements individually. You have now created a professional-looking cover page all with a few clicks of the mouse.You can now navigate your computer files and select an image to use instead, click Insert once you have selected the new image.Preview the report again and notice that now there is no page number shown on the cover page, the page number shown on page 2 is 1, and successive pages show correct page numbers. This is usually 1, and it is 1 in our example. ![]() ![]() Subtract from the page number the number of pages in the cover page. Right-click the textbox containing the page number and select Expression…. Next, we’ll adjust the actual numbers so that the first data page displays as page 1. In the Page Footer Properties window, uncheck the Print on first page checkbox and click the OK button. Right-click in the page footer and select Footer Properties… First, let’s suppress the page number on the cover page. Also, the second page of the report shows page number 2 we want that to print as page 1 and the successive pages to print as 2, 3, and so on. This looks good, but notice that there is a page number on the cover page we want to suppress that. Verify that page 1 is the cover page and that your report data starts on page 2. Preview the report to see the cover page (Print Layout view is best). We’ll also need to drag the dotted line at the top of the page footer up a bit to remove some of that white space between the data region and the page footer. To avoid pagination issues, adjust the subreport so that it is up against the top of the report header, as wide as the CoverPage report it contains, and short enough so that it doesn’t overlap the data region. Also notice that the height of the main report increases to accommodate the subreport we just dropped in it. At first, it will probably overlap your data region and look a little messy. The subreport will appear as a gray box with the name of the report it contains-in our case, CoverPage. 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. 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. 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. 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. 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.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |