Solved

SSRS Snapshot

Posted on 2013-10-29
4
151 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 39

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 65

Accepted Solution

by:
Jim Horn earned 500 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
t-sql Joining Issue 10 37
kill process lock Sql server 9 47
VBScript Write Column Headers 3 37
MSSQL Import .SQL files - Increase Import Speed 9 35
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

776 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