Using a hyperlink in sql server reporting services
I have added a table on to the body of my sql server report.In one of the columns of the table I have dragged a field which is the output of a stored procedure.
Now i want to make this field a drillthrough hyperlink(by using the jump to report option) based on a condition. I am not able to do that. Any idea how to achieve this?
Click the ... on the Action property of the column. Select jump to report. Click FX and you can put your expression into the expression editor. If you have complex logic you might need to define some custom code to return you the name of the report you want to jump to. Alternativly you can get the name of the report from the dataset. I also find it useful to use the tenerary expression if you have a true false scenario.
e.g.
SomeValue = Hello ? "Hello Report" : "Other Report"
Thanks for your answer.
I wrote an expression with a condition on action->jump to report. But it still showed me the hyperlink(hand cursor) over the values for which I didn't want a hyperlink.
The problem is that on the same column for some values I want a hyperlink and for some I dont want a hyperlink. So I have put that in the condition but it doesnt work out.
Any idea where I am going wrong?
Thanks in advance
I'm having a similar problem. However with mine, it's either the requested document or an hyperlink for a mailto: to request the document be restored based on a status condition of another field so the hyperlink for both is OK.
I want the document to open in a NEW window instead of the same window...the mailto does fine. I've tried about everything, so any tips would be greatly appreciated!!
Thanks!
Joanie
