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!

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.

How do you get dates to look sensibly formatted in SSRS parameters? This blog considers the issues, and appeals for help!

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.

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.

This blog shows how to create multivalue parameters based on dropdowns, whether in SQL Server Reporting Services or Report Builder 3.0.

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.

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!

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!

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!

Getting rows of a table to repeat at the top of each page of a report in SSRS 2008 R2 is anything but straightforward. This blog shows the red herring to avoid and a way to solve this thorny problem.

SQL Server Reporting Services 2008 R2 includes (among many other features) the ability to detect a report's rendering format, together with a facility for naming report pages. You can combine these two features to create Excel workbooks with individually named worksheets for each member of a group, as shown in this blog.

SQL Server Reporting Services 2008 introduced gauges, in all their dazzling compexity. This free tutorial blog shows how to create gauges, format their pointers and scales, add labels and much else besides.

Indicators are one of the nicest new features of SSRS 2008 R2 (or SQL Server Reporting Services, to give the software its full name). This blog shows how to add indicators to a table, format them and set scaling correctly.

Outlining grouped data in Reporting Services 2008 should be straightforward: you just set the ToggleItem property of rows, and away you go! Unfortunately this owl can't get this to work - along with a lot of other people it seems - so we offer this solution.