CODEWITHSUNDEEP
sql-serverreporting-servicessubreportdrilldownssrs-2017
SQlOra
SQlOra

Reputation: 13

SSRS drill through report, How do I locate the referencing report name from main report

I have a report (developed by a previous employee), some of the columns(data) are clickable, when clicking the number(data on some of the columns) it opens another report. But when in the design mode from the first report, I could not figure out the relation to any of the clickable report name. I have checked Action property and almost with my knowledge all possible, but still unable to locate the reference/pointer to another report. Could you please let me know, how do I locate the reports? or the pointer. As I need to add a filter and columns to most of the reports. Any help would be greatly appreciated. Please let me know how do I find and fix the report as I need to add a filter and add a column to all reports.

Also, I think it's drill through the report but unable to locate the link for each column, the reports are deployed into the reporting server and accesses through the UI portal

The main report has 6 clickable columns and I see all six reports in the reporting server as well. But not sure how those are connected and how the parameters are passed, as I need to add a new parameter and new columns to all the reports except the main report

Please let me know if you need more information Thank you

Upvotes: 0

Views: 612

Answers (1)

Yogesh
Yogesh

Reputation: 1

I also faced the same issue while exploring an old SSRS report and after struggling for an hour I found the previous developers have defined this action property on the field's action property inside a textbox. So instead of looking at the textbox action property, look at the field's action property and you will find the drill through report name and parameters passed.

Upvotes: 0

Related Questions