Share via

linking to two different sub reports from the same cell

db042190 1,521 Reputation points
2021-08-11T12:08:22.407+00:00

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?

SQL Server Reporting Services
SQL Server Reporting Services

A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.

0 comments No comments

Answer accepted by question author

Olaf Helper 47,621 Reputation points
2021-08-12T05:11:54.04+00:00

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.

Was this answer helpful?

0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 47,621 Reputation points
    2021-08-11T12:33:25.927+00:00

    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.

    Was this answer helpful?


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.