A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
Hi @Nik Clark ,
Do you mean you are using report drill-through? That is, when you click on a chart, dashboard, etc. in a report, you will jump to the corresponding other report, right?
If you have drillthrough in your report, the reports that need to be linked are all deployed on the same report server at the same time, but they can exist in different folders.
When the drill operation in the main report fails, it can be considered as:
- Other reports drilled by the main report are not on the same server or are missing or cannot be retrieved. If you are using Visual Studio to create reports, you can redeploy your local Project to the report server.
- A drillthrough report usually contains detailed information about the items contained in the original summary report, and often includes parameters that filter the drillthrough report based on parameters passed to the drillthrough report from the main report. Please check if the parameter settings are lost.
- If you upgrade to SSRS2016 Edition, you should also consider that the report is not automatically upgraded successfully. In this case, it is still recommended that you redeploy to the report server.
If I misunderstand what you mean, please feel free to correct me.
Best Regards,
Joy
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.