Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2011-02-23
11
Medium Priority
?
1,236 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:rhservan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 

Author Comment

by:rhservan
ID: 34962051
Also, the subreport passes startdate & enddate parameters.
0
 
LVL 10

Expert Comment

by:itcouple
ID: 34964083
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
0
 

Author Comment

by:rhservan
ID: 34964559
Yes, I already tried that in the browser and as a link in the excel to no avail.  What else?
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
LVL 10

Expert Comment

by:itcouple
ID: 34964796
Hi

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

Regards
Emil
0
 

Author Comment

by:rhservan
ID: 34965208
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.
0
 
LVL 10

Expert Comment

by:itcouple
ID: 34965366
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
0
 

Author Comment

by:rhservan
ID: 34965489
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
0
 
LVL 10

Accepted Solution

by:
itcouple earned 2000 total points
ID: 34967806
Hi

I see now. In the past I have used Go To URL and expression to make it work and should work both in SSRS and Excel. I will have a go with your approch but the obstacle I see that when you use report manager; it understands your "action" because it knows the "context" (extra hidden information) while exporting to excel it might lose the "context!".

Remember that in report manager you use unwillingly use asp.net which helps you use actions and in order to generatelly environment independed link you need to construct it in a specific way and your excel link isn't close to what it should be based on my knowledge and experience.

Regards
Emil

0
 
LVL 10

Expert Comment

by:itcouple
ID: 34967810
Sorry for gramma erros I just got up ;)
0
 

Author Comment

by:rhservan
ID: 34970061
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.  :)
0
 
LVL 10

Expert Comment

by:itcouple
ID: 34970114
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

0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question