• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 174
  • Last Modified:

SSRS Snapshot

I thought this would be simple but I cant seem to find the answer. I have a summary report and detail report that generate snapshot history everyday. The summary report has a parameter link that takes it to the current detailed report. Is there a way to link snapshots done at the same time?
  • 2
1 Solution
lcohanDatabase AnalystCommented:
As far as I know if you snapshot the parent SSRS report the linked reports are also executed and snapshot taken. Please create linked reports for any missing subreports in the same location as the main report.
countyprobSystem AnalystAuthor Commented:
Thank you for your quick response.  I now realize I am using the wrong terminology Reporting Service linked report is not the same as opening the report via hyperlink.  The two reports use the same dataset. There is a hyperlink in the summary report that opens a detailed report for each group in the summary group. Both reports have snapshots at the same time. How do I make sure the Summary report opens the appropriate  detail report, the snapshot done at the same time
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>How do I make sure the Summary report opens the appropriate  detail report,
On the textbox's right-click:Properties, Action event
Select the 'detail' report in the 'Specify a report' combo box.
Add all of the parameters that report needs in the 'Name' combo boxes.
Add whatever parameter or text box name whose value should pass for those parameters in the 'Value' combo boxes.
countyprobSystem AnalystAuthor Commented:
Obviously I am dense today. The only parameter that I am aware is the group , there must be a parameter that describes a report snapshot.  My goal  is if you click on the group link in the a snapshot summary report you get a group detail report snapshot that was done at the same time.,
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now