Solved

SSRS Snapshot

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
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.

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now