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.
Knowledge base / Since 1999
SQL Server Reporting Services Tutorials & Guides
Practical SQL Server Reporting Services tutorials, troubleshooting notes and implementation guides from real projects.
Advanced search38 entries / SQL Server Reporting Services
Clear filters
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.
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.
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...
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...
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...
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?
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...
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...
Loading more notes...
No more notes to load.