Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SSRS Snapshot

Posted on 2013-10-29
4
Medium Priority
?
173 Views
Last Modified: 2014-11-21
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?
0
Comment
Question by:countyprob
  • 2
4 Comments
 
LVL 40

Expert Comment

by:lcohan
ID: 39609638
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.
0
 
LVL 1

Author Comment

by:countyprob
ID: 39610123
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
0
 
LVL 66

Accepted Solution

by:
Jim Horn earned 2000 total points
ID: 39610148
>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.
0
 
LVL 1

Author Comment

by:countyprob
ID: 39610186
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.,
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question