- SSRS SUBREPORT EXPORT TO PDF BROKEN HOW TO
- SSRS SUBREPORT EXPORT TO PDF BROKEN CODE
- SSRS SUBREPORT EXPORT TO PDF BROKEN PROFESSIONAL
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.
SSRS SUBREPORT EXPORT TO PDF BROKEN 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.
SSRS SUBREPORT EXPORT TO PDF BROKEN PROFESSIONAL
It can add clarity to your report and give it a clean, professional look. As an added bonus, it also preserves bullet points related HTML tags as Project Server users typically like to enter their comments in bullet points.A cover page is simply a page that comes before the report data and that usually contains a report title and other identifying information. The removeHTML function strips all the HTML codes except for new line so that your text doesn’t appear all on the same line. (Use your Multiline text field name instead of Project_Description)ģ) In report designer, select the text > in your text box and set MarkupType property as HTML. =Code.RemoveHTML(Fields!Project_Description.Value) Public FUNCTION RemoveHtml(ByVal Text As String) AS Stringĭim objRegExp AS NEW (“”)Ģ) In your desired textbox in the report, use the following expression to display your multiline field:
SSRS SUBREPORT EXPORT TO PDF BROKEN CODE
Follow the solution below to fix this space problem.ġ) Add the following code to your report by right clicking outside the report body and then selecting Report Properties. The same report looks fine on screen and exports with proper spaces to Microsoft Word. When a SQL Server Reporting Services 2005, 2008 or 2008 R2 report gets exported to PDF, the spaces of a Project Server Multiline text field appear so condensed, that it looks like a long line with out any spaces. Posted by: EPM Partners on March 12, 2014Īt EPM Partners we come across this issue quite frequently and so we would like to share the solution with you.