Data Driven Subscription

How to Speed up MS SQL Reporting Services on First Run

I set up a new instance of MS SQL Server Reporting Services, but I noticed that it starts up very slow and I have to wait for ages to access the site. I also noticed that it is always slow when it has not been used for a certain period of time.

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.

Resend Failed Scheduled Reports on Demand in SSRS

This Stored procedure re-sends the failed reports subscriptions on Demand.

Getting Started with Maps in SQL Server 2008 R2 Reporting Services

I noticed a new feature in SQL Server 2008 R2 Reporting Services that allows you to render maps in your reports. Can you provide some details on this new feature and can I take advantage of it even though don't have any spatial columns in my data warehouse?

Conditional report rendering based on render formats for SSRS Reports

When using Report Manager, users can export reports to different formats like PDF, XLS and others. When reports are exported to other formats they also include all of the content from the report, but rendered to the format of the report output. There maybe scenarios where you would not want a particular part or component of report to appear in these other report formats. A practical example of this could be that you want to display images when the report is displayed in HTML, but not when the report is exported to a PDF format. In this tip we take a look at a new feature in Reporting Services that allows us to control these items without having to create multiple report versions.

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.

Reporting Services 2008 R2: Geospatial Visualization – Part I

Geospatial Visualization is one of the key new features of SQL Server 2008 R2 Reporting Services. This step-by-step tutorial demonstrates the creation of a Map Report.

Expert Systems – an SSRS Approach

An interesting approach to solving a complicated problem using SSRS. Users have too much documentation to read about a process, so Jonathan Spink introduces a better way to do things.

Reporting Services Disaster Recovery

Dave Lumley presents a Reporting services disaster recovery solution for SQL Server Standard Edition, using 2 servers. Worth the read if you don't run Enterprise.