A sub-report will behave as a hyperlink if it is formatted as an On-Demand sub-report.
In design view for the main report, right click on the sub-report and click on Format Subreport and on the Subreport tab unselect On-demand Subreport.
Hope this helps.
Cheers, Pete.