Does the 'Jump to URL' action work in SSRS 2008?
I'm using Visual Studio 2008, and SQL 2008 Developer edition. I have Microsoft SQL Server Reporting Services Designers Version 10.0.1600.22 I'm rendering reports with Microsoft.ReportViewer.WebForms, Version 9.0.0.0.I've had reports working with the 'Go to Report' action (Hyperlink action in the rdl) for some time now. I need now to have some reports link out of SSRS to a custom application. I had planned on setting a 'Jump to URL' action on certain textboxes. When I do this in the VS designer, and preview the report, a new tab opens in my broser. All well and good.However, if I render a deployed report (in html) either in my app using ReportViewer or directly out of the Report Manager, I get the hotspot with the 'Finger' appearing over the textbox, but clicking on the link does nothing. At first I thought this was a data error because I knew that this was the behavior you observed if the url wasn't valid, but I've verified my data and tested the report with trivial url's like http://www.microsoft.com. It does in fact work in VS designer (valid url) but it does not work in ReportViewer. 1) Does anyone have a deployed 2008 report which renders the jump to url correctly in html? I've seen alot of questions about 'Go to Report', but that's not my problem.2) Can anyone think of something I'm not thinking of, like is there some sort of security setting on SSRS that stops reporting services from linking out? 3) Is this a Microsoft bug?I would really like a response on this. IF this is a MS error, then this is the third major show stopping bug I've come across in SSRS 2008. The previous two - incorrectly rendering charts with dynamic sizing and not correctly passing data to an adjacent row group when there was also a column group in the tablix - cost me a couple days of work, but I could work around them. I don't see a work around in this case because the url is not static, and isn't something I can just add to the rendered report with a javascript or css hack. I would like to know ASAP whether or not this is a bug because if it is I need to go to marketting and tell them to remove references to this functionality from upcoming marketing releases.Thanks,Matt
January 8th, 2010 12:41pm

1) Yes, Jump to URL works correctly for me. I am using the Enterprise edition with sp1.(Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) ). As developer Edition and enterprise are almost same i expect similar behavior there also. Also as you stated your build as 10.0.1600.22 . This is RTM version of Sql i.e. The first public, supported version of SQL Server 2008. So there might be issue with that build. So Please install Sp1. and then compare your build with this http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx ~~ Mark it as Answer if you find it correct~~
Free Windows Admin Tool Kit Click here and download it now
January 8th, 2010 1:23pm

Thanks for replying.I installed Sp1 and I am still observing the same behavior when using the ReportViewer or Report Manager. I looked over the issues that the updates to SQL2008 are supposed to address, and none seem to reference an issue like this.I will endeavor to see if I can replicate the issue using a trivial report.
January 11th, 2010 2:24pm

did you tried trivial url's like http://www.microsoft.com . Also restart the Reporting service..~~ Mark it as Answer if you find it correct~~
Free Windows Admin Tool Kit Click here and download it now
January 15th, 2010 12:27pm

Yeah, I tried a trivial URL. Nothing worked.After my last post, I set out to provide instructions for reproducing the problem. However, the problem proved elusive to replicate. Eventually, the sample report I was creating to reproduce the problem duplicated all the functionality of the original without producing the hyperlink missing when rendered error. I then replaced the problimatic report with the apparantly identical one and this fixed the problem.There is clearly some way in which the xml can get janked (possibly by adding and backing out groups or table cell merges) since the original report would have been created with more false starts than the duplicate, however at this time I've not the time to do a comparison between the xml of the current report and the one that was originally giving me problems to see what was different under the surface. If anyone else encounters the problem, I advise them to start over on a fresh report and see if they can avoid whatever subtly janks the xml.
January 15th, 2010 2:24pm

I am seeing this behavior as well, I have the XML from the text boxes that are exhibiting this behavior. I changed the URLs but as Matt explained it is not a bad URL causing the problem. I'm comparing these to the XML from other text boxes that are set up in identical ways that are not exhibiting the broken functionality. I haven't been able to see any differences. Maybe someone can shed some light.<Textbox Name="Textbox7"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Criterion 11, </Value> <Style> <FontFamily>Calibri</FontFamily> <FontWeight>Bold</FontWeight> <TextDecoration>Underline</TextDecoration> <Color>Blue</Color> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> <Paragraph> <TextRuns> <TextRun> <Value>Manual eval</Value> <Style> <FontFamily>Calibri</FontFamily> <FontWeight>Bold</FontWeight> <TextDecoration>Underline</TextDecoration> <Color>Blue</Color> </Style> </TextRun> </TextRuns> <Style /> </Paragraph> </Paragraphs> <rd:DefaultName>Textbox7</rd:DefaultName> <ActionInfo> <Actions> <Action> <Hyperlink>="javascript:void(window.open('http://www.google.com'))"</Hyperlink> </Action> </Actions> </ActionInfo> <Style> <Border> <Style>None</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style></Textbox>In this text box I even tried putting the hyperlink on the text and the textbox but ReportViewer still does not recognize the link on either. <Textbox Name="tde_dlg"><CanGrow>true</CanGrow><KeepTogether>true</KeepTogether><Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!tde_dlg.Value</Value> <ActionInfo> <Actions> <Action> <Hyperlink>="emc2://TRACK/DLG/" &amp; Fields!tde_dlg.Value &amp; "?action=EDIT"</Hyperlink> </Action> </Actions> </ActionInfo> <Style> <FontFamily>Calibri</FontFamily> <FontWeight>Bold</FontWeight> <TextDecoration>Underline</TextDecoration> <Color>=iif(Fields!row_num.Value&gt;1,"Red","Blue")</Color> </Style> </TextRun> <TextRun> <Value>=iif(Fields!row_num.Value&gt;1," *Duplicate*","")</Value> <Style> <FontFamily>Calibri</FontFamily> <FontWeight>Bold</FontWeight> <TextDecoration>Underline</TextDecoration> <Color>=iif(Fields!row_num.Value&gt;1,"Red","Blue")</Color> </Style> </TextRun> </TextRuns> <Style> <TextAlign>Right</TextAlign> </Style> </Paragraph></Paragraphs><ActionInfo> <Actions> <Action> <Hyperlink>="emc2://TRACK/DLG/" &amp; Fields!tde_dlg.Value &amp; "?action=EDIT"</Hyperlink> </Action> </Actions></ActionInfo><Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <BackgroundColor>=iif(RunningValue(Fields!src_dlg.Value,CountDistinct,Nothing) Mod 2&gt;0,"LightGreen","White")</BackgroundColor> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom></Style>
Free Windows Admin Tool Kit Click here and download it now
January 29th, 2010 11:19am

Had similar issue. I had Hyperlink action as "Go to Report" in 2-3 reports. All worked fine. Suddenly when deployed an existing "SaleSummary" report, the drilldown(Action -> Go to report) on "Quantity" textbox stopped working on this particular report. I compared the XML of "SaleSummary" with another report which also has drilldown functionality and that works fine. Found "SaleSummary" "Quantity" textbox "LeftIndent" and "HangingIndent" were set to 0cm. After clearing the Indent properties and was able to Drill down successfully. (By deleting "<LeftIndent>0cm</LeftIndent> <HangingIndent>0cm</HangingIndent>" lines from my report XML) So the problem is down to "Indent" property of report. I was able to easily reproduce this. Hope this helps you.
February 12th, 2010 6:48am

I have encountered the same issue today. The resolution however seems to be different in a different cases e.g. on my 1st report there were no “Ident” properties but I had to remove the following piece of code (see below) which was generated somehow by the designer. In another case I had an Action on a cell and an action in the placeholder within this cell although it worked fine in VSS it did not when it was rendered through ReportViewer. I managed to sort out this one by removing action from the placeholder. Hope this helps! <TablixCell> <CellContents> <Textbox Name="Textbox5"> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Test</Value> <Style /> </TextRun> </TextRuns> <Style /><!-- Remove </Paragraph> <Paragraph> <TextRuns> <TextRun> <Value /> <Style /> </TextRun> </TextRuns> <Style /> </Paragraph>--> </Paragraphs> <rd:DefaultName>Textbox5</rd:DefaultName> <ActionInfo> <Actions> <Action> <Hyperlink>http://microsoft.com</Hyperlink> </Action> </Actions> </ActionInfo> <Style> <Border> <Color>LightGrey</Color> <Style>Solid</Style> </Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </Style> </Textbox> </CellContents> </TablixCell>RK
Free Windows Admin Tool Kit Click here and download it now
March 17th, 2010 11:46am

Hello all, I have just experienced the same problem (SSRS 2008 w/ SP1). I have a report with two Tablix, both having a 'Jump to URL'-action in the detail header. Both actions are working within BIDS, but the second action is not working in the web browser (even if I put a constant URL as target). In my case the solution was to remove the value of the SpaceBefore-property. best regards, Gerald
April 19th, 2010 6:50am

Holy ____... that indent idea fixed my problem. Awesome!
Free Windows Admin Tool Kit Click here and download it now
November 4th, 2010 9:01pm

I have the same problem and I've checked both the Indent and SpaceBefore property and neither is set. Any other ideas out there? And yes, we ARE in Sharepoint Integrated mode.
January 7th, 2011 10:49am

Similar thing but in Project Server environment. I want to link from a SSRS report to the appropriate Project Workspace page. A URL like http://google.com works. Any Project Server URL is not even recognised as being a link - no pointing finger. I started out with a variable but have been testing with a hard-coded URL and it just doesn't work. Any ideas gratefully received. Denis
Free Windows Admin Tool Kit Click here and download it now
October 24th, 2011 3:32am

Similar thing but in Project Server environment. I want to link from a SSRS report to the appropriate Project Workspace page. A URL like http://google.com works. Any Project Server URL is not even recognised as being a link - no pointing finger. I started out with a variable but have been testing with a hard-coded URL and it just doesn't work. Any ideas gratefully received. Denis This may be a different problem than what is described in this thread. The problem I was experiencing was that no URL whatsoever would be recognized in the report. I never isolated the problem, but based on the above comments it would probably be a good idea to manually strip all of the unnecessary tags (empty paragraph tags, indent tags, spaceing tags, etc.) out of the textbox in question. If that doesn't work, it probably has something to do with not recognizing your Project Server URL as a valid URL.
April 24th, 2012 8:41am

I know this is old, but I just came across this issue in SSRS 2008 at a site that won't be updating in a looong time. The indent 'css' properties take precendence and overwrite the url action. As soon as I took the indent out the go to url action worked. But I need to use expression driven indents for presentation of optional dynamic parameter driven grouping. I eventually realised that indent/cell padding are the same thing from a presentation perspective. So I just moved my indent expression to the LEFT PADDING property and deployed it. The indent/padding was there and the go to url action still worked!
Free Windows Admin Tool Kit Click here and download it now
July 18th, 2012 11:36pm

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

Other recent topics Other recent topics