I have a report with fields that can be clicked to open a sub-report. I implemented this functionality by selecting the field that I wanted to be "clickable" and then specifying "navigate to report" as the action property.
The issue is that when a user clicks on the link to navigate to the sub-report, the sub-report loads over top of the current report. The user is then unable to navigate back to the parent report without having to reenter the parameters and run the report again.
I'm looking for a way to open the sub-report in a new tab/window but I do not see an option to do so. There is an option to open a URL in a new window but we don't have a way to pass parameters into the URL which would be needed to populate the sub-report.
Is there a workaround to navigate to a report and have that report open in a new tab/window? Our team is using Report Designer so we're unable to create user functions.
Thanks in advance.