Export To EXCEL/WORD IE7 IE8 Help
Using SSRS 2008 - IE8 - I can open a new window using the following javascript from my primary page, but when I export the page to either Excel2003 or Word2003 and try to click on the link I get a pop-up showing my javascript string and at the bottom I get "Hyperlinks can be harmful to your computer and data. To protect your computer click only t." There is a choice of yes no. I click yes and get an IE error stating "Internet Explorer cannot download unspecified error." Any help on this is greatly appreciated. ="javascript:void(window.open('http://server.com/ReportServer/Pages/ReportViewer.aspx?%2fSPARS%2fSPARStdaf&rs:Command=Render&rc:Parameters=true&RptMonth=" & Parameters!RptMonth.value & "&Reports='+escape('" & Parameters!Reports.label & "')+'" & "&ID=" & Fields!ID.Value & "&Alias='+escape('" & Fields!KPI.Value & "')+'" & "&BD=" & Parameters!BD.Value & "&ED=" & Parameters!ED.Value &" ','_blank','width=975, height=435, top=55, left=25, toolbar=1, menubar=1, location=1, status=1, scrollbars=1, resizable=1'))"
February 14th, 2011 11:37pm

Hi RudyCat, Your issue might not be relevant to Reporting services directly, I notice that the URL is correct, the issue seems to be relevant to hyperlink warning messages in Office, please refer to below links to get some reference: 1. How to disable hyperlink warning messages in Office 2003 http://support.microsoft.com/kb/829072 2. "Internet Explorer Cannot Download" Error Message When You Use an HTTPS URL to Open an Office Document or PDF File http://support.microsoft.com/kb/812935 Thanks, Challlen FuChallen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please 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
February 16th, 2011 5:59am

Thanks Challlen - The problem is that once the Reporting Services page is exported to Excel or Word for that matter, the link no longer works and I get that hyperlink warning message. It used to work before the company moved from Internet Explorer version 7 to version 8. So this is a Microsoft issue. Anyone else having this problem?
February 20th, 2011 4:40pm

Using SSRS 2008. I have a main report page that has a go to URL section. It requires a new window to be opened for the linked sub report. It works fine in opening the new window using this javascript expression ="javascript:void(window.open('http://my.server.com/ReportServer/Pages/ReportViewer.aspx?%2fSPARS%2fSPARStdaf&rs:Command=Render&rc:Parameters=true&RptMonth=" & Parameters!RptMonth.value & "&Reports='+escape('" & Parameters!Reports.label & "')+'" & "&ID=" & Fields!ID.Value & "&Alias='+escape('" & Fields!KPI.Value & "')+'" & "&BD=" & Parameters!BD.Value & "&ED=" & Parameters!ED.Value &" ','_blank','width=975, height=435, top=55, left=25, toolbar=1, menubar=1, location=1, status=1, scrollbars=1, resizable=1'))" Problem occurs when the user exports the main report to Excel or Word and tries to click on the link. The link attempts to open a new window and an error occurs providing a pop-up box stating "Internet Explorer cannot download. Unspecified error". The ability to link to the sub report within Excel(2003) & Word(2003) used to work using IE7, but doesn't in IE8. Any help on this is greatly appreciated.
Free Windows Admin Tool Kit Click here and download it now
February 24th, 2011 8:45pm

Hi RudyCat, Based on your information, I think this issue might be relevant to office or IE setting. However I still want to cooperate with you to narrow down this issue, could you please open the subreport from main report via IE directly not the exported word to see whether it work fine, if so I think it is not the issue of Reporting services. Besides this, you could also change the URL to below to open the subreport directly to achieve the similar effect. ="http://my.server.com/ReportServer/Pages/ReportViewer.aspx?%2fSPARS%2fSPARStdaf&rs:Command=Render&rc:Parameters=true&RptMonth=" & Parameters!RptMonth.value & "&Reports='+escape('" & Parameters!Reports.label & "')+'" & "&ID=" & Fields!ID.Value & "&Alias='+escape('" & Fields!KPI.Value & "')+'" & "&BD=" & Parameters!BD.Value & "&ED=" & Parameters!ED.Value &" ','_blank','width=975, height=435, top=55, left=25, toolbar=1, menubar=1, location=1, status=1, scrollbars=1, resizable=1'" This is the similar thread, please get some reference from it http://social.msdn.microsoft.com/Forums/en-US/iewebdevelopment/thread/2b646ea9-c032-4c85-92b1-087518592485 Thanks, Challen Fu Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
February 25th, 2011 7:08am

Challen, I appreciate your assistance. I used the URL code you provided and received this error. An error occurred during client rendering. An error has occurred during report processing. (rsProcessingAborted) Cannot read the next data row for the dataset DataSet1. (rsErrorReadingNextDataRow) Conversion failed when converting date and/or time from character string. I do need this to open in a new window. I used the previous URL with the Javascript and it works fine in opening the subreport. Again when exporting the main report to either Excel or Word and try to click on the URL to get to the subreport from within Excel or Word is when I get the error, "Internet Explorer cannot download. Unspecified error". Something has changed between IE7 & IE8 that causes this since the exact same code worked with IE7.
Free Windows Admin Tool Kit Click here and download it now
February 25th, 2011 3:41pm

Conversion failed when converting date and/or time from character string. You need to examine the data in your data source. Example for the above error: SELECT CONVERT(datetime, 'FEBX 25, 2011') /* Msg 241, Level 16, State 1, Line 1 Conversion failed when converting date and/or time from character string. */ Datetime conversion link: http://sqlusa.com/bestpractices/datetimeconversion/ The ISDATE function can be used to validate a string date. Kalman Toth, Admin/Prog, SSAS, SSIS, SSRS; SQL 2008 GRAND SLAM
February 25th, 2011 4:03pm

Hey Kalman, Thanks for your response. I used the original syntax and had no problems. The data is fine. When I used the suggested syntax from Challen is when I received that error. I am more interested in why the exported report to Excel or Word does not retain the link to the subreport. ="javascript:void(window.open('http://velma.fmr.com/ReportServer/Pages/ReportViewer.aspx?%2fSPARS%2fSPARStdaf&rs:Command=Render&rc:Parameters=true&RptMonth=" & Parameters!RptMonth.value & "&Reports='+escape('" & Parameters!Reports.label & "')+'" & "&ID=" & Fields!ID.Value & "&Alias='+escape('" & Fields!KPI.Value & "')+'" & "&BD=" & Parameters!BD.Value & "&ED=" & Parameters!ED.Value &" ','_blank','width=975, height=435, top=55, left=25, toolbar=1, menubar=1, location=1, status=1, scrollbars=1, resizable=1'))"
Free Windows Admin Tool Kit Click here and download it now
February 25th, 2011 4:27pm

Conversion failed when converting date and/or time from character string. You need to examine the data in your data source. Example for the above error: SELECT CONVERT(datetime, 'FEBX 25, 2011') /* Msg 241, Level 16, State 1, Line 1 Conversion failed when converting date and/or time from character string. */ Datetime conversion link: http://sqlusa.com/bestpractices/datetimeconversion/ The ISDATE function can be used to validate a string date. Kalman Toth, Admin/Prog, SSAS, SSIS, SSRS; SQL 2008 GRAND SLAM
February 25th, 2011 5:48pm

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

Other recent topics Other recent topics