Trigger SSRS report when particular table is updated in the database

5 pts.
Tags:
SQL Server Reporting Services
SSRS
SSRS reports
Hi,

I need Trigger or run the SSRS report automaticallty and deliver to my email when some updates happens in particular table. Is that Data driven subscriptions is solution for the above or any other methods to be done. Looking forward you answer quickly

 

Thanks



Software/Hardware used:
SSRS

Answer Wiki

Thanks. We'll let you know when a new response is added.

Yes a data driven subscription is what you want to use.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • GeoffD

    You could trigger the report to run by submitting it's eventId to the processing engine

    I use a combination of a view which shows all scheduled reports and a simple job to submit them.

    The view is:

    CREATE VIEW [dbo].[Schedule View]

    AS

    SELECT TOP (100) PERCENT rs.ScheduleID,

    rs.ReportID, c.Name,

    dbo.Subscriptions.ExtensionSettings, dbo.Subscriptions.Description, dbo.Subscriptions.LastStatus, dbo.Subscriptions.LastRunTime,

    dbo.Subscriptions.EventType, dbo.Subscriptions.Parameters, dbo.Subscriptions.DeliveryExtension, dbo.Subscriptions.Version,

    dbo.Schedule.EventData, dbo.Subscriptions.SubscriptionID, c.Path

    FROM dbo.ReportSchedule AS rs WITH (nolock) INNER JOIN

    dbo.Catalog AS c WITH (nolock) ON c.ItemID = rs.ReportID INNER JOIN

    dbo.Subscriptions WITH (nolock) ON rs.SubscriptionID = dbo.Subscriptions.SubscriptionID AND c.ItemID = dbo.Subscriptions.Report_OID INNER JOIN

    dbo.Schedule WITH (nolock) ON rs.ScheduleID = dbo.Schedule.ScheduleID

    ORDER BY rs.ScheduleID

    Fields can be changed as you see fit. To include reports in the view they need to have been scheduled to run at least once.

    You can then use the following to generate a report:

    insert into reportserver.dbo.[Event]
    ([EventID], [EventType], [EventData], [TimeEntered], [ProcessStart], [BatchID])
    select NewID(), 'TimedSubscription', [EventData], GETUTCDATE(), NULL, NULL
    from Reportserver.dbo.[schedule view]
    Where (Name = 'My Report Name')

    Hope this helps.

    20 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following