We have SSRS 2008 r2 rdls. I open an SSRS report and keep it open in my browser for more than 30 mins. If I now click any drill downs either through an action or go to report. I don't want the report to get me that info. It should state that the report is expired.

Is there a solution already available? Do future version SQL server have a solution for this?


That's not how it works.

When you click a link in an existing report it basically opens the linked report with the parameters in the URL.

The target report has no clue about the rendering date of the source report.

If you want to accomplish anything like this you would have to pass the rendering datetime of the main report as a parameter to the subreport and have the subreport check that (every single one of them).

As far as I know there isn't a general setting and you would have to modify every drill-through action to send a parameter based on the datetime of rendering and modify each target report to check on it and render an error message if the parameter exceeds a certain threshold.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.