How do I jump to another report based on a value

How do I jump to another report based on a value in my current report?

Right-click on the field you wish to link, select Navigation, select jump to report, and specify the report and any parameters required.

Here are a couple of links that may help.

http://msdn2.microsoft.com/en-us/library/aa964132.aspx

http://www.codeproject.com/useritems/InputParmReport.asp?df=100&forumid=290297&exp=0&select=1472409

cheers,

Andrew

|||

Thanks Andrew,

The examples that you gave me are based on parameters. I made a mistake. What I actually need is to be able to jump to a

report based on a value in one of the report columns. The report that I am jumping from has no parameters and is just a table with

columns and values. How can I do this?

|||

Hi,

you can use the hyperlink action "jump to report" using an expression like this:

=IIf(Logical_Expression, "reportname 1", "reportname 2")

Best regards

Sven

|||

Hi Sven

I tried doing this and it jumps to the report. The problem I am encountering is that the whole column is being enabled to jump rather than just the selected being enabled when the user passes his cursour over it. How do I enable just that value and not all the column values?

|||Hi,
then you have to use the switch-function instead of the iif-function.
=switch(Logical_Expression, "reportname")
br
Sven