Reporting Services Report Builder Tips

You need to edit a SSRS report, but you do not have the source code. How do you get it?

I have many reports that allow users to select a year filter from a dropdown list. Is there a way that I can define this query once then reference it in multiple reports? In this tip we walk through how this can be done.

One of the many new features in SQL Server Reporting Services 2008 R2 is one called Report Parts. You can publish parts of a report then reuse those parts in other reports. In this tip I will demonstrate how to take advantage of this new feature.

In a previous tip we looked at how to determine which indexes were being used for a SQL Server 2005 database. "Databases have two primary storage needs; data pages and index pages. Understanding and viewing the actual data in your tables is pretty straightforward by running some sample queries to get an idea of what columns are being used as well as what type of data is actually being stored. On the flip side of this, it is often difficult to know exactly what indexes are being used and how they are being used. So how can you get a better understanding of how your indexes are being used and what operations are occurring (inserts, updates, deletes, selects)?" To take this original tip a step forward, the following Reporting Service

I have heard that there is a new version of Report Builder in SQL Server 2008. Can you provide some details and examples? What is new with Report Builder 2.0? How does the new interface look? What is the learning curve with this tool?

Report Builder is Microsoft's report authoring tool for business users. It has a simple and intuitive user interface that is similar to Microsoft Office. This tutorial will cover what you need to know to get started authoring reports with Report Builder 3.0, which was released with SQL Server 2008 R2.

I have heard that there is a new version of Report Builder in SQL Server 2008. Can you provide some details and examples? What is new with Report Builder 2.0? How does the new interface look? What is the learning curve with this tool?

Report Builder is Microsoft's report authoring tool for business users. It has a simple and intuitive user interface that is similar to Microsoft Office. This tutorial will cover what you need to know to get started authoring reports with Report Builder 3.0, which was released with SQL Server 2008 R2.

I have many reports that allow users to select a year filter from a dropdown list. Is there a way that I can define this query once then reference it in multiple reports? In this tip we walk through how this can be done.

One of the many new features in SQL Server Reporting Services 2008 R2 is one called Report Parts. You can publish parts of a report then reuse those parts in other reports. In this tip I will demonstrate how to take advantage of this new feature.

You need to edit a SSRS report, but you do not have the source code. How do you get it?

In a previous tip we looked at how to determine which indexes were being used for a SQL Server 2005 database. "Databases have two primary storage needs; data pages and index pages. Understanding and viewing the actual data in your tables is pretty straightforward by running some sample queries to get an idea of what columns are being used as well as what type of data is actually being stored. On the flip side of this, it is often difficult to know exactly what indexes are being used and how they are being used. So how can you get a better understanding of how your indexes are being used and what operations are occurring (inserts, updates, deletes, selects)?" To take this original tip a step forward, the following Reporting Service

Report Builder is Microsoft's report authoring tool for business users. It has a simple and intuitive user interface that is similar to Microsoft Office. This tutorial will cover what you need to know to get started authoring reports with Report Builder 3.0, which was released with SQL Server 2008 R2.

One of the many new features in SQL Server Reporting Services 2008 R2 is one called Report Parts. You can publish parts of a report then reuse those parts in other reports. In this tip I will demonstrate how to take advantage of this new feature.

I have many reports that allow users to select a year filter from a dropdown list. Is there a way that I can define this query once then reference it in multiple reports? In this tip we walk through how this can be done.

You need to edit a SSRS report, but you do not have the source code. How do you get it?

I have heard that there is a new version of Report Builder in SQL Server 2008. Can you provide some details and examples? What is new with Report Builder 2.0? How does the new interface look? What is the learning curve with this tool?

In a previous tip we looked at how to determine which indexes were being used for a SQL Server 2005 database. "Databases have two primary storage needs; data pages and index pages. Understanding and viewing the actual data in your tables is pretty straightforward by running some sample queries to get an idea of what columns are being used as well as what type of data is actually being stored. On the flip side of this, it is often difficult to know exactly what indexes are being used and how they are being used. So how can you get a better understanding of how your indexes are being used and what operations are occurring (inserts, updates, deletes, selects)?" To take this original tip a step forward, the following Reporting Service