Link to home
Start Free TrialLog in
Avatar of rhservan
rhservanFlag for United States of America

asked on

When I export an SSRS 2008 report to excel, why won't my links work?

In the report I have a column which is a link to a subreport.  This works fine in SSRS 2008.

When I export the same report to excel 2003 my links won't work in excel with this error:
Unable to open
h-t-t-p://reportserver/?%2fStopReport&ShipHeaderSK=9&StartDate=10%2f12%2f2010+00%3a00%3a00&EndDate=03%2f04%2f2011+00%3a00%3a00&rs%3aParameterLanguage=
Cannot locate the internet server or proxy server.
Avatar of rhservan
rhservan
Flag of United States of America image

ASKER

Also, the subreport passes startdate & enddate parameters.
Hi

In SSRS 2008 Report Server hover the link, right click and select copy short cut, Paste it in new Browser window and see if that works. If yes do the same in excel and see if there any slightest differences.

Hope that helps
Emil
Yes, I already tried that in the browser and as a link in the excel to no avail.  What else?
Hi

Can you attach spreadsheet with sample (or screenshot how it looks after taking out the sensitive data)?

Regards
Emil
Where the link is concerned, it is just that, a link.  Blue, underlinded & hyperlinked with the http url above in the properties of the link.  Which is the exact link in the actual report in SSRS which works.  This link also provides the parameters passed to the subreport.  

I would prefer not to send the data or spreadsheet to you at this time unless you can tell me a specific piece of information you are looking for.  I believe the link information above would be most helpful.

Let me know.
Hi

You mentioned that you have exactly the same link in Excel and SSRS. Have you tried copying them and using then in new browser window? If there are exactly the same they should provide exactly the same response.

The link above contains h-t-t-p which doesn't look properly, also it ends with = not sure if there should be a value for that.

Send us the expression you use to generate the link in SSRS (sample) so I can check the syntax and do a similar one and see how it is exported to excel on my machine.

Regards
Emil
The dashes are to prevent establishing a link in this question.

I have attached a graphic of the supreport configuration which is called from the link
ReportGraphic.png
ASKER CERTIFIED SOLUTION
Avatar of itcouple
itcouple
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Sorry for gramma erros I just got up ;)
Hi, I am back on line.
I dont care about the spelling or grammar, I just want to get through this. Just be the guru you were meant to be.  :)
Hi

I have already given you the answer (Use URL). I'm not giving detailed instructions for two reasons:  One I have better things to do, two it is not my job to do it :p

Regards
Emil