I am using SQL 2008, adding an action to a textbox to go to url "http://www.google.com". Using Visual Studio's preview, the hyperlink works properly. Once the report is deployed to the report server, the hyperlink is not workingusing the Report Manager to view the rendered report (HTML rendering). Is there a property for the rendering of reports to include hyperlinks like the report viewer control has? Note: I am NOT using the Report Viewer control that has the EnableHyperlinks property.When hovering the mouse over the textbox on the rendered report, the mousewill change to the hand icon telling me that it thinks there is a link but clicking the textbox does nothing. It looks as though the hyperlink code was stripped out during the rendering.Looking at the code for the .rdl shows: < ActionInfo><Actions><Action> < Hyperlink>="http://www.google.com"</Hyperlink> </ Action></Actions></ActionInfo>

Hi Lesley, We just talked about it. 1) Did u try all of this (URLs in reports may only use http://, https://, ftp://, mailto: or news:) or you can try at least first three and check. 2)Put: ="javascript:void(window.navigate('http:// *** The path to page you want to navigate to *** '))" in the Jump To URL property. A quick workaround based on (http://www.mssqltips.com/tip.asp?tip=1283 ) is to use javascript to navigate to the page. http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/3af8a3b5-cdc6-4a24-bac1-8851ff949fe7/ http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/5efe07a6-1ff3-4bfa-baf3-717f7f431c6f/ Thanks, Absar

Basically I have a report that displays a list of documents put on our system and I want to link the documents back to the file server so I can display the docs. To eliminate permission/domain/etc issues, I am trying to hyperlink to a standard url like google.I have tried http:// and mailto: with the same results - the links work in preview but not after it is deployed to the report manager.I read on a blog somewhere to try changing the // to \\ to trick the report renderer to think that it isn't a hyperlink - but that didn't work.I also wrapped up the link in the ="javascript:void(window.open...." code to have it open in a new window with no success.I was able to remove the hyperlink and put a placeholder on the text box that embedded html code so that it would be returned as part of the document and "trick" the report server. IE: ="<a href='<url>'>" & docname & "</a>". This worked on my local copy of my report manager but not on the real report server setup in a secure area. I didn't really want to do this because of security violations that it imposes.Our UI doesn't use the report viewer object because we have our viewstate turned off. We have an iframe and use urls to return the report. While looking at the source code returned from the report server, it never returns the links in the code. My hyperlinks set up under the action sections are just text embedded in <scan> sections and the rendering of the report must strip the links out. I'm guessing that there is some setting in the report server that will allow the links to be rendered like the property in the ReportViewer control but I haven't found anything like this yet.All the books say that this functionality is possible but I can't seem to get it to work properly. I can hyperlink to other reports just not non-report urls.

Hi Lesley,All you have done is fine.I suppose the issue is caused by the network environment. Could you please ask the domain administrator to check if the hyperlink is blocked in your environment?By the way, are you using Report Manager not a custom web application to view the report?http://<server>/reportsI have met some cases that if using IFrame, we may encounter a security issue.Thanks,Jin ChenJin Chen - MSFT

I'm experiencing similar problems, so I don't think that it is a network specific problem.I'm using SSRS 2008 and the web version of ReportViewer.I get a 'hotspot' on the report, but clicking on it causes no action to be taken. This happens whether the report is rendered in the report manager or in the ReportViewer. There is no real sign in the rendered HTML of the link.The link works in the designer in Visual Studio.

I have exactly the same problem as Lesley and Matt. I'm also using SSRS 2008 and the web version of ReportViewer.In the designer everything works well, but in the rendered html there's no sign of a link...

Arno: I spent a while investigating this, but never found the exact cause. It's clearly a microsoft bug. Unfortunately, I don't have time to do MS's work in quality assurance for them, because I have my own deadlines to meet and products to create. At some point, when I have a little down time I'm going to go into the xml and figure out what in that unreadable mess is the problem.In the mean time, let me suggest that the problem appears to be related from repeatedly adding or removing groups, or merging and unmerging table cells. I was able to resolve the problem by starting a fresh report and making a step by step copy of the original. The copy had identical functionality and structure, but it rendered without the missing hyperlinks bug of the first report. So clearly, if you head down a false path and back out at some point (the only difference between the original and the copy), something under the hood breaks in a way that the designer can cope with, but the reportviewer/renderer can not.At some point, I'm going to do a code compare on the two documents and figure out where the bug is in the tablix, but for now I have other things to do.In any event, try the procedure I suggested. It's tedious to redo all your work, but its the only thing I found that works.

i am having the same issues as Matt Reynolds I'm using Visual studio 2008 and the web version of ReportViewer. nothing happens to the textboxes at all when I set the navigation option .... just displays data without a link.

Hi there,I had the same issue, and found the problem was due to the fact that the display content of the hyperlink was made up of multiple place holders. For example, if the textbox contained [Placeholder1] [Placeholder2], the link would show fine, and work fine in Visual Studio, but NOT in a browser. If I changed the textbox to just contain [Placeholder1], the link displayed, and worked fine in Visual Studio, and in a browser.If I changed the textbox expression to be =Fields!Field1.Value & " "& Fields!Field2.Value, the link displayed, and worked fine in Visual Studio, and in a browser.So it appears to be a bug with multiple placeholders in a single textbox, where the textbox has an Action.Hope this helps.Jon

I'm having a weird problem myself, and after reading through the responses, mine seems isolated to a problem with using the same server name as the link. The report (as others have stated) worked fine in design, but wouldn't render in a browser. So I tried "http://msdn.microsoft.com", and that worked fine. I then tried to point to "http://other-server/path/site" and that worked fine in a browser (complete with a nice ?ID= and &Source=<encrypted return url>. The problem, at least for me, seems to center around using "http://same-server-report-is-on/path/site/DisplayForm.aspx?ID=[tp_ID]&Source=<encrytped url back to report>", I tried using just "http://same-server-report-is-on/path/site", without all the extra hocus-pocus and it won't render it. It will render every link I try 'except' point to anything on the server itself. Ideas?

Hello, I read through this tread trying to find some answer as I've had the same problem as many others here. In a table I added a column with the link I wanted to access, this was returned from a query field. The actual field data was not connected to any query field, I just typed a manual caption "Link" with hyperlink URL e.g. http:\\myserver\mysite\mypage.aspx When debugging the report the link worked fine. But when running as a normal user, the links could not be opened. When exporting report results to PDF or Excel, the links still worked fine. When I tried exporting to MHTML and viewing source I could see there was no links at all in the page. I changed one of the other table cells, which was bound to a query field, and pointed that to the same link (also a query field) and with that I got it working. Doing a new export and view source of MHTML I can now see the links. Hope this helps someone else, I've now spent half a day struggling with this. Glenn