SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts with tag Reporting Services (SSRS) Rss

Search for any content tagged reporting services (ssrs)

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 14 of 14   

Stored Procedure to export report output to a file to any location

I've created a Stored Procedure that allows for any deployed (SSRS) report to be exported to any location in an available file output format. Requires an rss file (VB) and xp_cmdshell enabled on the SQL Server.   Read more...
By Will Beaton 2016/03/03 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 3,252 reads

Report Server Report Usage

Get information about how often, how fast your reports run and how big they are.  Read more...
By Dennis Post 2012/12/12 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 1,548 reads

SSRS Execution Log Queries

A few brief selects to expose snippets of data which may be useful for debugging larger issues.  Read more...
By Rik Thwaites 2012/08/27 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 1,324 reads

Fix SSRS Subscription Owners

Stored procedure to update SSRS Subscription owners to avoid email errors.  Read more...
Rating: |  Discuss |   Briefcase | 1,002 reads

Data Driven Subscription - SQL Server Standard Edition

A simple example of using T-SQL and the Boomerang framework to create a data driven subscription.  Read more...
Rating: |  Discuss |   Briefcase | 1,444 reads

Last month Name and Year in a SSRS expression

Show the last month and year in a expression, based on a parameter called asofdate. Must format Date Month Year  Read more...
By Jeff Ridings 2011/11/08 | Source: SQLServerCentral.com | Category: dateadd
Rating: |  Discuss |   Briefcase | 1,208 reads

Resend the reports scheduled to send on today's date

This stored Procedure grabs the reports scheduled to run on today's date and reruns the subscriptions on demand.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 854 reads

Resend Failed Scheduled Reports on Demand in SSRS

This Stored procedure re-sends the failed reports subscriptions on Demand.   Read more...
Rating: |  Discuss |   Briefcase | 914 reads

retrieve SSRS report schedule info through SQL

Grabs information about what reports in SSRS are scheduled, when are they due to be sent out, report parameters and any errors in the last run etc.  Read more...
By Ibrahim Naji 2014/02/21 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 2,521 reads

Finding Ratio between two numbers

This function finds the ratio betwen two numbers.Just plug into your SP and enjoy.  Read more...
By Srikanth 2010/06/23 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,553 reads

Report Subscription Dynamic File Names

a way to programatically change the filename of email attachments in report subscriptions.  Read more...
By Mark Terry 2010/06/24 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 1,116 reads

Listing Subscribed SSRS Reports including Parameters & their Values

This script will allow user to analysis their Subscribed Reports.  Read more...
Rating: |  Discuss |   Briefcase | 1,797 reads

Stored Procedure to maintain RSExecutionLog

An alternative to the SSIS approach to maintaining an RSExecutionLog database for Reporting Services supplied by Microsoft  Read more...
By Perry Dyball 2010/05/21 | Source: SQLServerCentral.com | Category: rsexecutionlog
Rating: |  Discuss |   Briefcase | 1,975 reads

Report failed SSRS subscriptions

Generates a dataset for determining when subscriptions fail to send e-mail or post reports to file shares.   Read more...
By toolman 2008/12/10 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 1,148 reads
   Items 1 to 14 of 14