Hi Hoping someone could help. I have a report and I'm trying to programmatically cause the creation of a report execution snapshot. I am NOT using report history snapshots. The report has a data driven subscription and I have the "When the report data is updated on the report server" option selected as my trigger. My understanding is that this means that when the report execution snapshot is refreshed that condition will be met and my subscription will fire. in Report Manager on the report properties execution tab, when I check the box "Create a report snapshot when you click the Apply button on this page" and Apply everything works - so essentially I am trying to reproduce this in code. Here is a snippet of my code. The call to ResetExecution doesn’t seem to do anything. I don’t get an error, nothing happens that I can see on the report server ... ReportExecution2005.ReportExecutionService rs = new ReportExecutionService(); rs.Url = reportServerURL; rs.Credentials = System.Net.CredentialCache.DefaultCredentials; ExecutionInfo ex = rs.LoadReport(reportPath, null); ex.AllowQueryExecution = true; ExecutionInfo ex2 = rs.ResetExecution(); // this doesnt seem to do anything Console.WriteLine(String.Format("rpt {1} and {0} and {2}", ex2.ExecutionDateTime.ToString(), ex2.ReportPath, ex2.HasSnapshot.ToString())); // nothing changed ...

Hi Carlson, For "so essentially I am trying to reproduce this in code.", use ReportingService2005.CreateReportHistorySnapshot Method to do it. See http://msdn.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createreporthistorysnapshot(v=SQL.90).aspx on the method sytax. The link http://msdn.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005_members(SQL.90).aspx gives more details about ReportingService2005 web serivce methods. thanks, Jerry

hi Carlson, Do you able to solver your problem? IF yes please help me give correct code snippet. Thanks, Murali

hi Carlson, Do you able to solver your problem? IF yes please help me give correct code snippet. Thanks, Murali

hi Carlson, Do you able to solver your problem? IF yes please help me with correct code snippet. Thanks, Murali