Solved

Event based Scheduling of the reports

Posted on 2010-11-16
3
1,071 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 15

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 15

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

Suggested Solutions

Title # Comments Views Activity
Security manage in SSRS 1 89
Ssrs date parameters 12 179
SQL query to summarize items per month 5 85
SSRS Deployment to Web Error 1 36
Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

734 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