BICTT - Latest comments on SQL Reporting Services Render PDF in A4 paper size instead of Letter

Alexis Kravetz [Visitor] in response to: SQL Reporting Services Render PDF in A4 paper size instead of Letter

Alexis Kravetz [Visitor] — Wed, 08 Sep 2010 05:47:31 +0000

That was a different thought track. I admire your quality that you put into your work. P

island vacations [Visitor] in response to: SQL Reporting Services Render PDF in A4 paper size instead of Letter

island vacations [Visitor] — Tue, 07 Sep 2010 13:19:42 +0000

You appear extremely knowledgeable inside your sphere.

Harold Sortor [Visitor] in response to: SQL Reporting Services Render PDF in A4 paper size instead of Letter

Harold Sortor [Visitor] — Sun, 05 Sep 2010 04:04:42 +0000

Amazing stuff,Many thanks so much for this!This is very Helpful Article for me. This will Completely going to Support me in my Tasks .

Lupe Motamedi [Visitor] in response to: SQL Reporting Services Render PDF in A4 paper size instead of Letter

Lupe Motamedi [Visitor] — Fri, 03 Sep 2010 15:27:59 +0000

Amazing Article Maki. Like Examining copywriting book from Joe Sugarman or Dan Kennedy. Now I just have to apply the

wow power leveling [Visitor] in response to: SQL Reporting Services Render PDF in A4 paper size instead of Letter

wow power leveling [Visitor] — Fri, 03 Sep 2010 08:42:16 +0000

ryer

Isaac Keeble [Visitor] in response to: SQL Reporting Services Render PDF in A4 paper size instead of Letter

Isaac Keeble [Visitor] — Fri, 03 Sep 2010 06:52:26 +0000

Your Weblog article is very intersting and fanstic,at the Exact time the Weblog theme is unique and perfect,great job.To your

Hunter Bagwell [Visitor] in response to: SQL Reporting Services Render PDF in A4 paper size instead of Letter

Hunter Bagwell [Visitor] — Fri, 03 Sep 2010 03:18:26 +0000

Really great, practicly explained and Helpful Guidelines.

Insurance Lawyers Los Angeles [Visitor] in response to: SQL Reporting Services Render PDF in A4 paper size instead of Letter

Insurance Lawyers Los Angeles [Visitor] — Wed, 28 Apr 2010 08:19:30 +0000

This seems to not work with SQL 2008 version of reporting services. I am trying to find out why. As soon as I know I will share.

Dipen Parekh [Visitor] in response to: SQL Reporting Services Render PDF in A4 paper size instead of Letter

Dipen Parekh [Visitor] — Thu, 08 Apr 2010 14:31:48 +0000

Hi davida,

If the text renders as a hyperlink (which it should since you have attached an action to it.) then it should work. Also this will not work in Preview mode, it works only after you deploy it to a report server

Please make sure if you have attached an action to the textbox by going to Text Properties then select 'Action' from left then select Go to URL' and enter the value as I mentioned previously.

Thanks,
Dipen

davida [Visitor] in response to: SQL Reporting Services Render PDF in A4 paper size instead of Letter

davida [Visitor] — Fri, 26 Mar 2010 13:28:38 +0000

Hi Dipen, i am trying to use your solution but, the report is not opening a new window or displaying in the adobe reader window. i used your example to display as text and can copy the url, paste into a browser and get the desired results. i am not sure if the action is not firing or if i have missed something.
thanks

Dipen Parekh [Visitor] in response to: SQL Reporting Services Render PDF in A4 paper size instead of Letter

Dipen Parekh [Visitor] — Thu, 11 Mar 2010 15:23:49 +0000

Another possible way of rendering the pdf in the required size is by using the url access feature of SSRS.

Note: This applies only if you have very few report parameters since URL length limit in SSRS is 256 characters.

All you have to do is add a textbox in the header area of the report, give some text value as "Export to PDF" and in the 'Action' section of the textbox select 'Go to URL' and give the URL expression as below

=Globals!ReportServerUrl + "?"
+ Globals!ReportFolder + "/"
+ Globals!ReportName + "&rs:Command=Render"
+"&rs:Format=PDF"
+"&rc:PageWidth=11 in"
+"&rc:PageHeight= 15 in"
+"&Param1=" + CStr(Parameters!Param1.Value)
+"&Param2=" + CStr(Parameters!Param2.Value)

The values for PageWidth and PageHeight can be made even more dynamic by getiing it from an internal Parameter which can be varied based on some condition in the report, then the URL expression will look like

=Globals!ReportServerUrl + "?"
+ Globals!ReportFolder + "/"
+ Globals!ReportName + "&rs:Command=Render"
+"&rs:Format=PDF"
+"&rc:PageWidth=" + CStr(Parameters!PDFPageWidth.Value) +"in"
+"&rc:PageHeight=" + CStr(Parameters!PDFPageHeight.Value) + "in"
+"&Param1=" + CStr(Parameters!Param1.Value)
+"&Param2=" + CStr(Parameters!Param2.Value)

You may also want to hide the text "Export to PDF" in the PDF genereated then in that case use another hidden parameter (it should be an hidden parameter and not an internal parameter) and then set the visibility of the text box to Show Hide based on an expression and give the paramter for its value parameter name,
then the URL expression will look like

=Globals!ReportServerUrl + "?"
+ Globals!ReportFolder + "/"
+ Globals!ReportName + "&rs:Command=Render"
+"&rs:Format=PDF"
+"&rc:PageWidth=" + CStr(Parameters!PDFPageWidth.Value) +"in"
+"&rc:PageHeight=" + CStr(Parameters!PDFPageHeight.Value) + "in"
+"&HideExporttoPDF=true"
+"&Param1=" + CStr(Parameters!Param1.Value)
+"&Param2=" + CStr(Parameters!Param2.Value)

Bob Cornelissen [Member] in response to: SQL Reporting Services Render PDF in A4 paper size instead of Letter

Bob Cornelissen [Member] — Mon, 18 Jan 2010 07:33:49 +0000

Hi Markus, are you using a sharepoint integration like in http://msdn.microsoft.com/en-us/library/bb326358.aspx ? I will play with the sharepoint integration again soon on my dev boxes and will certainly try and see what happens. I do not have an idea why this would happen.

Markus [Visitor] in response to: SQL Reporting Services Render PDF in A4 paper size instead of Letter

Markus [Visitor] — Thu, 14 Jan 2010 14:35:42 +0000

Have an issue when rendering to PDF on the Dev box the pdf looks great. When rendering from share point the rendering to pdf is making columns go to 2 lines. using an arial norrow 5 font.

Any idea?

Bob Cornelissen [Member] in response to: SQL Reporting Services Render PDF in A4 paper size instead of Letter

Bob Cornelissen [Member] — Thu, 17 Dec 2009 14:13:32 +0000

Added update for SQL 2008 version. Remember to change that one word in the extension line and to restart IIS completely.

Bob Cornelissen [Member] in response to: SQL Reporting Services Render PDF in A4 paper size instead of Letter

Bob Cornelissen [Member] — Thu, 17 Dec 2009 12:15:47 +0000

This seems to not work with SQL 2008 version of reporting services. I am trying to find out why. As soon as I know I will share.

Kapila [Visitor] in response to: SQL Reporting Services Render PDF in A4 paper size instead of Letter

Kapila [Visitor] — Wed, 16 Dec 2009 10:06:22 +0000

I tried doing the same thing as suggested above but could not see the custom PDF extension in the export drop down list .

Bob Cornelissen [Member] in response to: SQL Reporting Services Render PDF in A4 paper size instead of Letter

Bob Cornelissen [Member] — Mon, 16 Nov 2009 17:58:54 +0000

Rendering to Word is not included in SQL 2005 reporting services. There is a third party solution at http://www.aspose.com/categories/ssrs-rendering-extensions/aspose.words-for-reporting-services/default.aspx but it looks expensive.

However it is included in SQL 2008 Report Services. I have not yet looked into possible Letter to A4 differences with that one, but it should be possible in the same way as mentioned above I assume.

Glenn [Visitor] in response to: SQL Reporting Services Render PDF in A4 paper size instead of Letter

Glenn [Visitor] — Wed, 28 Oct 2009 03:09:09 +0000

Great stuff. This worked. Can you also export to Word?

Stewart Anderson [Visitor] in response to: SQL Reporting Services Render PDF in A4 paper size instead of Letter

Stewart Anderson [Visitor] — Mon, 01 Jun 2009 22:21:56 +0000

Awesome, fixed it perfectly, thanks :)

Adam [Visitor] in response to: SQL Reporting Services Render PDF in A4 paper size instead of Letter

Adam [Visitor] — Tue, 31 Mar 2009 03:30:55 +0000

Thanks very much. This fixed a gripe I'd had with Reporting Services that I hadn't really looked in to fixing until now.

Appreciate your effort in spelling it out so simply.