« SQL CPU running at 100 percent on SCOM Reporting ServerFastCGI PHP on Windows 2008 »

17 comments

  1. § Adam said on :
    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.
  2. § Stewart Anderson said on :
    Awesome, fixed it perfectly, thanks :)
  3. § Glenn Email said on :
    Great stuff. This worked. Can you also export to Word?
  4. § Bob Cornelissen® Email said on :
    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.
  5. § Kapila Email said on :
    I tried doing the same thing as suggested above but could not see the custom PDF extension in the export drop down list .
  6. § Bob Cornelissen® Email said on :
    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.
  7. § Bob Cornelissen® Email said on :
    Added update for SQL 2008 version. Remember to change that one word in the extension line and to restart IIS completely.
  8. § Markus Email said on :
    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?
  9. § Bob Cornelissen® Email said on :
    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.
  10. § Dipen Parekh Email said on :
    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)
  11. § davida Email said on :
    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
  12. § Dipen Parekh Email said on :
    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
  13. § dominique Email said on :
    Hello Bob,
    I did the change on the Data Warehouse server, IISRESET and restart SQL Reporting Services. Now I am checking the RMS but I don't see the two new options...
    These are two different servers (DW1 and RMS1) did I miss a step?

    Thanks,
    Dom
  14. § dominique Email said on :
    *****
    Hello Bob,

    Sorry I missed the comment Update 17 december 2009 on SQL 2008 version:

    In the lines of code please use "PDFRenderer" in stead of "PDFReport

    it works like a charm now.,..

    Thanks,
    DOm
  15. § dominique Email said on :
    Hi Bob,

    The change works fine... BUT the report content remains the same it just have more blank on the right side of the page as it is in landscape instead of portrait !!! I was expecting the chart to expand on the landscape format to make it less crowdy within the 8" ... expanded to 11"

    Thanks,
    Dom
  16. § Bob Cornelissen® Email said on :
    HI Dom,
    this is a change in the SSRS config file followed by an iisreset. If you than run another report you should be able to export it in those formats. Otherwise shoot me a private email and we'll see how to solve it.
  17. § Anneliese Denos said on :
    I blog often and I truly thank you for your information. This great article has really peaked my interest. I'm going to take a note of your website and keep checking for new information about once per week. I subscribed to your Feed as well.

Leave a comment

You must be a member of this blog to comment. Log in now!

Contact / Help. ©2014 by Bob Cornelissen. evoCore.
Design & icons by N.Design Studio. Skin by Tender Feelings / Evo Factory.