linking to two different sub reports from the same cell

Question

Hi we run 2014 enterprise. We are contemplating a new drill thru sub report. It would be most natural to link to it from our account number cell in the parent report. but there is already another sub report that gets linked to from that cell. There is no other parameter or data set value that would allow us to guess what the user had in mind when they hit enter on the link.

Is there a way to use what key the user hit to choose which sub report gets linked to? Or some other trick for this class of challenge? Maybe they hit a function key instead of enter to link to the new report?

Answer 1

you are suggesting a new column with hard code or image?

"Hard coded" wasn't the right term I used, more a text box with a fix text, like "Goto account1", "Goto account2" and so on.
Yes, simple add column with a control you prefer.

Answer 2

Or some other trick for this class of challenge?

You can use a hard coded text box with content "Goto detail", passing the account number to the sub report, or you use an image.