Post reply

How do you call the report server and tell it to give you the report in PDF format?

  • January 30, 2009 at 12:12 pm

    #199414

    I've seen the following work with SSRS2000 in the past:

    -- IN ASP

    Response.ContentType = "application/pdf"

    Response.Redirect("http://ReportServer/Path/ReportName/&rs:Command=Render&Parameters&rs:format=PDF")

    Now with SSRS2005, it's just displaying the whole page in the Report Manager Rendering Plug in. From here I can choose to export to PDF if I like and that works fine.

    I've been going Google searches, but I'm just not sure I'm searching for the right thing, so if anyone has some tips, clues or ideas on how to get this working or where the parameter/QueryString documentation is, then I would be very grateful.

  • February 2, 2009 at 2:16 pm

    #936745

    You might need some sort of custom rendering extension. You can read more about it in BOL... http://msdn.microsoft.com/en-us/library/ms156281(SQL.90).aspx

    Perhaps one that runs the report and delivers it to a specified directory where you can then open it in Acrobat Reader?

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • February 2, 2009 at 2:24 pm

    #936748

    Also here's the info from BOL on using URL params...

    http://msdn.microsoft.com/it-it/library/ms153586(SQL.90).aspx

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • February 3, 2009 at 9:58 am

    #937286

    I found the error... a rookie error.

    I was pointing to the path in the Server interface, not the actual report running path. Once I changed the path, it came up as PDF as expected.

    Bookmarked. Thanks very much. I was having trouble trying to search for the right terms to bring up these resources 🙂

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply