Scripts, systems & field notes.

SQL Server Reporting Services 15 Apr 2014 21439

SSRS Display question mark when date is blank

So I have a column in an SSRS report which displays a date. Being rather pernickety, I would like a question mark to display if there is no date to populate the field.

Read note →

SQL Server Reporting Services 11 Apr 2014 20738

SSRS No Delay for First Report of the Day

This article describes a solution our reporting server administrators found to cut the loading time of the first report of the day.

Read note →

SQL Server Reporting Services 09 Apr 2014 39550

SSRS Stop Scrolling Behind

I recently revamped our standard report with a new template comprising of a single Tablix which contained the images of the corners and sides of the report. It looked beautiful if simply displayed on a single page (the top half of the page) as long as the end-user doesn't scroll. If the page was scrolled, what should d...

Read note →

SQL Server Reporting Services 08 Apr 2014 29932

SSRS Change Background Color of Image

Sounds easy but actually if you use an image which has transparent areas, ie. has one color which will be transparent, the transparent pixels will be colored in with the page background color.

Read note →

SQL Server Reporting Services 07 Mar 2014 47149

SSRS: Performance Improvements: SELECT TOP

This article details a method we used on a search form in a SQL Server Reporting Services (SSRS) environment. The requirement (amongst others) was that the report ran in less than a few seconds. Analyzing the report through the ReportServer databases (internal auditing) only showed how long the SQL query would take to...

Read note →

SQL Server Reporting Services 20 Jan 2014 24356

SSRS Border Problem

A very quick note on why borders may be misbehaving in SSRS. This note corrects the situation at Design time. This is where you are trying to select a cell to have an outline border but then cells around it without a border. You may find that BIDS or Report Builder (however you're building your report) will apply the b...

Read note →

SQL Server Reporting Services 30 Nov 2013 28345

Problem creating SSRS report subscriptions

A quick article on if you are trying to create a new subscription to a SQL Server Reporting Server (SSRS) report and you are getting a warning message similar to the following: Message from webpage Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the...

Read note →

SQL Server Reporting Services 25 Nov 2013 35323

SSRS Subscriptions cannot be created

This article describes solutions to the error: Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid. How?

Read note →

SQL Server Reporting Services 19 Jan 2012 162842

Returning Oracle Stored Procedure Resultset in SSRS

So I've spent a fun time googling and binging but still haven't found a simple and complete example of getting a resultset from an Oracle stored procedure and displaying this in SQL Server Reporting Services (SSRS). Well "non-productive" more than "fun" as most of the examples on the net are either half-complete or par...

Read note →