Lots of people ask me about what is coming in the next release of SQL Server 2005 Reporting Services. I put together a white paper a few months back and it finally got posted to the web last week. There are a couple of things that aren't described there...

There is a cool new TechNet site available that has a nice aggregation of Reporting Services content. Check it out .

Jasper Smith has created a cool tool called Reporting Services Scripter that creates scripts from an existing Reporting Services server that you can use to apply to a new server. We have some new scripting functionality in the release of SQL Server 2005...

While the legend built into Reporting Services charts is relatively easy to use, it lacks some of the flexibility that you might like to have. One issue is that it takes up space within the chart boundaries, making the plot area smaller as the number...

Chris hasn't gotten a chance to update his Sleazy Hacks Weblog so I thought I would post this in the meantime. Resetting the page number in a report isn’t natively supported in Reporting Services, but there is a partial workaround. First, add this...

Another great resource for those of you who want to try out the new report controls in Visual Studio 2005 Beta 2. Check out the Web Log Analyzer Starter Kit at http://lab.msdn.microsoft.com/vs2005/downloads/starterkits/ .

If you are using the matrix control in Reporting Services, you may want to create a static heading over top of your column headers. For example: You might first try putting a text box on the body above the matrix. But if you don't know how many columns...

There a new article about upcoming release of Reporting Services from Steven Swoyer on the TDWI site. The only real quibble I have is with the "SQL-only" FUD from our competitors at the bottom of the article. As many of our customers know, Reporting Services...

While SQL Server Reporting Services supports a variety of built-in aggregates , one of the things that people ask for is the ability to define custom aggregates. While this is not directly supported in RDL, there is a trick you can do using the <Code>...

One of the Reporting Services authors, Teo Lachev, has written an article on the new Report Builder feature in SQL Server 2005 Reporting Services. In addition, his book, Reporting Services in Action , is an excellent guide for those of you looking to...

My marketing guys (who are really nice and not sleazy at all) would like me to encourage you to register for the SQL Server 2005 BI Webcast Series . I think I even will be doing a couple of them but I'm not sure which ones.

One of the cool new things in Visual Studio 2005 Beta 2 is the new Report Viewer controls. These controls make it easy to embed rich Reporting Services reports in your WinForms and ASP.NET applications. As one of the goals was to deeply integrate them...