Solved

Event based Scheduling of the reports

Posted on 2010-11-16
3
1,075 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 16

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 16

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

622 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