opening the ssrs report in pdf format using URL access
Jul 19, 2011 05:43 AM Dear Friends I have a popup window that opens a server report in PDF format using URL access . This does not work when Excel or pdf rendering is done (&rs:Format=Excel). When rendered to Excel or pdf, the popup opens and closes with out opening the report. With out PDF/Excel rending the url works just fine When the direct url is typed to IE the excel file opens without any issues, but does not work when tried to open in a popup. I have a series of code lines to be executed before the report is opened. Kindly Help Thanks for your Time Dim WindowName As String = "Test" Dim urlToOpen = "http://localhost/ReportServer$SQLEXPRESS/Pages/ReportViewer.aspx?%2fTDREPORTS%2fVoucherPrint&rs%3aCommand=Render&rs:Format=Excel&rc%3aParameters=false" Dim ScriptString As String = "<script language=javascript>window.open('" & urlToOpen & "','" & WindowName & "','resizable=1,scrollbars=1,width=760,height=680,left=2,top=2,toolbar=0,status=0,location=0,menubar=0');</script>" ClientScript.RegisterStartupScript(Me.GetType(), "KeyName", ScriptString) Nagendra
July 28th, 2011 7:18pm

Hi Nag_23, From your description, you need to open a new window and render a new report with PDF or Excel format. I did a test on my machine, if the URL address includes “&rs:Format=PDF” or “&rs:Format=Excel” parameter, it always pop-up a File Download dialog when click the hyperlink to open a new window and render a report. Since this behavior is by design. Here is a thread about render the exported PDF report in Internet Explorer (IE), please see: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/92b9590a-1b43-49e1-b4bb-357b31178ff4/ Thanks, Bin LongPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
August 3rd, 2011 1:48am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics