Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Disabling hyperlink for a report using report para

Author  Topic 

hi_i_am_amit
Starting Member

1 Post

Posted - 2010-05-05 : 01:38:32
We have a scenario where the rdl file contains conditional <Hyperlink> elements. The value for hyperlink is an expression build consisting of report parameters, field parameters etc and also calls to custom assemblies

eg : <Hyperlink>=Parameters!Param1.Value + CustomAssemblyCall + Fields!someField.Value<Hyperlink>

When this report is rendered by HTML Rendering extension(by specifying HTML4.0 in the format string passed to render() method) this
<Hyperlink> element is converted to href attribute of the <a> tag.

Report Parameters are basically used in the hyperlink tag to enable or disable the hyperlink at runtime. We make webservice calls to render the report. The problem comes when the hyperlink needs to be disabled.
The value set through the setExecutionParameters() web service call to the report parameter in order to disable it is hash ('#'). This works in some environments but doesn't in some. In some environments the hyperlink remains active still when mouse is hovered over the hyperlink and it points to the report server.

We validated the reporting services version on both environments (where it works and where it doesn't) and confirmed that they were same version (Microsoft SQL Server Reporting Services Version 9.00.4035.00).

Has anyone faced such an issue or have any clues on what could be going wrong?

Thanks,
Amit.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-05-05 : 02:28:37
cant you use an expression for hyperlink for enable disable? like for example:

=IIF(somecondition,Parameters!Param1.Value + CustomAssemblyCall + Fields!someField.Value,Nothing)

this will cause hyperlink to be active only for the condition specified

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -