Hyperlinking to another report

Im trying to create a link to another report from one of my fields (Budget_Reporting_Group_Description) but i only want the hyperlink to be visible and clickable for one value (Actual), how would i write out the code and where would i put it in the properties box for navigation. The report i want to link to is called Details.

I have this so far:

=Iif(Fields!Budget_Reporting_Group_Id.Value = "Actual", "Details", Nothing)

whats wrong?

Maybe you're not putting it in the correct place. The expression has to be placed in the expression for "Jump to report" under textbox properties -> Navigation tab.

-Aayush

|||

Hello,

Put this in the expression for your field, and in the "Jump To Report" of the navigation properties.

=Iif(Fields!Budget_Reporting_Group_Id.Value = "Actual", "Details", Nothing)

Now, if the Id is "Actual", then you will see "Details" in the textbox and it will be clickable, which will take you to your Details report. If it's not "Actual", then the textbox will be blank, with no hyperlink.

Hope this helps.

Jarret

|||I have it in the jump to report Expression box. But its not showing a hyperlink when i roll the mouse of the field. Is there another expression, or something to link it to another report. I just want the report to show a hyperlink if the value in the field is "Forecast" if not, it should not have a link to the other report.
|||thanks alot, i figure out what it was. I put the code in the jump to report, and changed the field from ID to Description, i made the mistake i putting ID , when i needed Description. Thanks for the help!