SSRS blogs
Showing blogs 1-20 (out of 25)
Posted by
Andrew Gould on 23 April 2013 | no comments
If you're using shared datasets to populate subreports in Reporting Services you might have encountered an error when you preview your reports. This short blog explains what the problem is and offers a few simple suggestions to work around the issue.
Posted by
Andy Brown on 01 October 2012 | 1 comment
By default SSRS will create files with extension .rdl.data to cache data. This blog gives two and a half ways to ensure you're always seeing the latest data in a report.
Posted by
Andy Brown on 06 August 2012 | no comments
This blog shows you how to use CSS style sheets to change the default appearance of the Reporting Services parameter strip.
Posted by
Andy Brown on 06 August 2012 | no comments
To make report navigation easier, you can create a 2-dimensional matrix of clickable links at the top of a report. This blog shows you how!
Posted by
Andy Brown on 06 August 2012 | no comments
Create a matrix whose row, column and data fields are all selectable from dropdown lists.
Posted by
Andy Brown on 06 August 2012 | 1 comment
A single report in Reporting Services can serve many masters. This blog shows how to allow a user to choose which data a report should display, using a dropdown parameter.
Posted by
Andy Brown on 03 August 2012 | 2 comments
A common requirement for Reporting Services reports is to colour alternate rows. This blog gives two approaches, one of which uses custom assemblies.
Posted by
Andy Brown on 03 August 2012 | 4 comments
Reporting Services allows you to write functions in C# or Visual Basic, then reference these as custom assemblies. This blog shows how - and why - you might do this.
Posted by
Andy Brown on 13 July 2012 | no comments
SQL Server Reporting Services allows you to write (and use) custom functions written in Visual Basic within a report. This blog considers the pros and cons, and shows how to do this.
Posted by
Andy Brown on 21 June 2012 | 6 comments
If you're not sure when - or whether - you should be using report or group variables in SSRS, read this blog to find out how to speed up your reports and solve other problems.
Posted by
Andrew Gould on 11 May 2012 | 3 comments
Unfortunately, Reporting Services doesn't have a simple setting that allows you to control the number of rows you see on each page. However, you can control this using a clever combination of an expression with a grouping level. Read this blog to find out how!
Posted by
Andy Brown on 08 May 2012 | 2 comments
SQL Server Reporting Services 2012 (SSRS 2012) has been completely rewritten (it's now called SQL Server Data Tools), and yet looks strangely familiar. This blog explains the new features introduced.
Posted by
Andy Brown on 24 February 2012 | no comments
How do you get dates to look sensibly formatted in SSRS parameters? This blog considers the issues, and appeals for help!
Posted by
Andy Brown on 30 January 2012 | 1 comment
A little nugget of information - how to arrange it so that a report written using SQL Server Reporting Services will keep refreshing automatically, to display the latest data.
Posted by
Andy Brown on 07 November 2011 | 1 comment
Report Builder and BIDS (the Visual Studio add-in for creating Reporting Services reports) are essentially the same underneath their very different looking skins. This blog lists the small number of differences.
Posted by
Andy Brown on 07 November 2011 | 2 comments
This blog shows how to create multivalue parameters based on dropdowns, whether in SQL Server Reporting Services or Report Builder 3.0.
Posted by
Andy Brown on 31 October 2011 | 1 comment
Struggling to install Report Builder 3.0 because of a message about the .NET 3.5 framework? The problem is more likely to be to do with Internet Explorer 9.0, as this blog explains.
Posted by
Andy Brown on 08 August 2011 | 1 comment
You can change the fill colour of data series in Reporting Services in a number of different ways, as explained in this article - but none of them allows you to set gradient or other effects. This blog is a rare appeal for help!
Posted by
Andy Brown on 26 July 2011 | 1 comment
Are we alone in continually coming across this bug? When you choose to change the number format in SQL Server Reporting Services 2008 R2 reports, the relevant dialog box vanishes!
Posted by
Andy Brown on 26 July 2011 | 2 comments
As you scroll down a report, the titles at the top of the page will disappear - this blog shows how to prevent this happening. It's not as easy as you would think!