How to link reports based on returned values

[riteshkini]

I want to a report to have hyperlinks, such that when you click on any link, another report is opened with contents based on the value clicked. i'm using SQL server 2000 right now. i'll be shifting on to IBM DB2 after sometime. Is there anyway to do this?

 

[pabloj]

At

http://www.lyontechnologies.com

you should find an example.
Anyway you have to use VBA SDK. Stick to your guns