I was just wondering whether it's possible, using SQL Server 2000 Reporting Services, to change which report to navigate to depending on the value of a certain field. I refer to the 'Action' property of a field where you can set what report (or url) to navigate to when a field is clicked.
So, for example,
If the value of a field is 1, navigate to an existing report called 'Report 1'
If the value of a field is 2, navigate to an existing report called 'Report 2'
.. and so on.
Can I do this using an expression in the 'Jump to report' option of the 'Action' property?..