SSRS No Delay for First Report of the Day
- Category: SQL Server Reporting Services
- Hits: 16678
This article describes a solution our reporting server administrators found to cut the loading time of the first report of the day.
Why?
Take any SSRS report, if one of us was the first to run it on that day, it would take an additional 60 seconds to get with it and display the report. Any subsequent running of the report loaded it almost immediately.
How?
SSRS Display question mark when date is blank
- Category: SQL Server Reporting Services
- Hits: 16946
- Microsoft SQL Server Reporting Services 2012
- Microsoft Visual Studio 2012 Premium
- Microsoft Windows 7 Enterprise
What?
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.
Why?
At the moment, the expression in there is something like this:
=Format(Fields!MyCompletionTime.Value, "dd/MM/yyyy HH:mm:ss") -- yields 11/02/2014 11:21:32Sounds good, where's the problem?
