Making values act as hyperlinks to sub reports

[bloombergCR]

Hi,

CRXI on SQL Server 2005

I have a report with invisible sup reports. Values on the main report should act as hyperlinks to sub reports. For example, a value displayed in main report as follows,

EligibleRules

Clicking it should show the detailed information on sub report.

Is it possible? and How to do it?

Thanks alot!

 

[AndyMc]

bloombergCR,

I don't know how to turn a value on your main report into a hyperlink to your subreport.

But you can turn your hidden subreport into an "On Demand" report. Right-click the subreport on your main report and choose "format subreport", go to the sub report tab, click on the On Demand check box. You can give it another hperlink name by clicking on the x+2 button called On Demand Caption (on the same tab) and enter the name you want to use in quotes - "Eligible Rules".

Andy

 

[bloombergCR]

I did exactly what you shared with me. Works very well.

Thanks alot!


Bloomberg