It is easy to create a basic matrix in Report Builder. However, it takes some practice in order to format and dispay the matrix exactly how you want it. There are a large number of options available to enhance the matrix and Robert Sheldon provides enough information to get you the point where you can experiment easily.  Read more...

With Report Builder and SSMS, there isn't much you can't do in the way of the common reports and visualisations. One of the more interesting visualisations uses maps, and that, combined with layers, makes for an impressive way of representing data.  Read more...

Use SSRS to be create its own lightweight report version control system  Read more...

Charts are one of the commonest ways of visualizing reports from data. Report Builder provides a way of generating charts and reports that will be intuitive to anyone who has done the same in Excel. Robert Sheldon provides a simple explanation of how to get the best from charts using Report Builder.  Read more...

There is a lot that can be done to make basic tabular reports more readable, using Microsoft's free Report Builder. Rob Sheldon continues his exploration of the power of this tool by showing how to format various elements within reports  Read more...

here is a lot that can be done to make basic tabular reports more readable, using Microsoft's free Report Builder. Rob Sheldon continues his exploration of the power of this tool by showing how to format various elements within reports.  Read more...

Should you be using Report Builder 3.0 or SQL Server Reporting Services 2008 R2 to build reports? Here's the 411!  Read more...

SQL Server offers a simple tool for business users to perform ad-hoc reporting.  Read more...

I’m getting my first taste of the new SQL Report Builder 2.0, and so far I’m enjoying the upgrade. Report Builder 2.0 is a standalone product, shipped as separate download from the SQL Server and Visual Studio suites. It allows users to develop and run reports locally, in addition to permitting the publication of these reports to SQL Server Reporting Services.  Read more...

I have heard that there is a new version of Report Builder in SQL Server 2008. Can you provide some details and examples?   Read more...

This paper introduces Microsoft SQL Server 2005 Report Builder and demonstrates how to build an end-to-end ad hoc reporting solution for enterprise customers using Report Builder and Microsoft SQL Server 2005 Analysis Services OLAP. We also highlight a few product limitations, as well as enterprise considerations. It is based on a real-world implementation by Microsoft Business Intelligence Center of Excellence.   Read more...