I have a report that runs perfectly when run from the server and using the link opens a new window no problem. I have written the path into the SQL of the stored procedure as such
'void(window.open('''+www.google.com+
''',''_blank''))'
my issue is that when the user downloads the report to Excel and clicks on the link it takes them to a download window.
Has anyone seen this before?
Can you format the link differently dynamically when the report is downloaded to Excel?