Solved

Event based Scheduling of the reports

Posted on 2010-11-16
3
1,058 Views
Last Modified: 2012-05-10
Can I schedule to run the SQL report, based on event. When the event happened the report
executes otherwise not. it continously checking for the event flag.
How to do this? Can we use the rs.exe command utility? How to usei t?

Is there any  ways to do the event based  scheduling of the reports?
Crystal reports have this option.But with SQL reports I didn't see anything. Please let me know in detail how to do this?

Thanks
0
Comment
Question by:KavyaVS
  • 2
3 Comments
 
LVL 13

Assisted Solution

by:Megan Brooks
Megan Brooks earned 500 total points
ID: 34147820
You can use the ReportingService.FireEvent("TimedSubscription", id) method to cause a subscribed report to execute. When I used this feature in the past, I created a subscription for the target report and set it to run once, at a date and time that was in the past. I then used a task in an SSIS package to execute the report (emailing it). FireEvent was called only when the data in the report changed.

You can find one example of how to do this here.
0
 

Author Comment

by:KavyaVS
ID: 34151922
Open Report Manager click on Site Settings then click on Site settings Security.

14.   Press Edit next to Generate events

15.   Then Click on System Administrator.

16.   Check the Generate events task.

I didn't find the Generate events link on Site settings Security. What to do?

Thanks

0
 
LVL 13

Accepted Solution

by:
Megan Brooks earned 500 total points
ID: 34152834
Yes, the user that calls FireEvent needs to have "Generate events" privilege. If I remember correctly, it was possible to assign this to a system role using Report Manager in SQL Server 2005. With SQL Server 2008 you will need to connect to the report server using SQL Server Management Studio, where you will find the system roles at the Security-->System Roles node.

You can either edit "System Administrator" and add the "Generate events" privilege to that or you can create a new system role with the additional privilege. You could call it "Event source" or whatever you would like. I think that would be a much better practice than extending System Administrator, because users that generate events probably don't as a rule need System Administrator privilege.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

705 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

20 Experts available now in Live!

Get 1:1 Help Now