Double Nickels on the Dime (Leaving the Reporting Services Team)

The rumors are true. I will be leaving the Reporting Service team after 7 years and SQL Server after 10 years. Here is the message that I sent to my team: It first dawned on me about 3 months ago that I had been in the same position for close to 10 years, nearly a…


Transmissions from the Satellite Heart (What’s up with Report Builder?)

Hopefully, you have gotten a chance to work with the latest CTP of SQL Server 2008 Reporting Services. But if you have, you may be a bit puzzled by the report design options in the CTP. Specifically: Report Builder looks just like it did in SSRS 2005. Report Designer is hosted in the VS 2005…


Tribal Thunder (SharePoint White Papers Available)

After many months of working on getting them posted, I’m excited to let you know that two whitepapers on the integration between SQL Server Reporting Services and SharePoint are now available. SQL Server 2005 Integration with Microsoft SharePoint Products and Technologies Troubleshooting Integration with SQL Server 2005 and Microsoft SharePoint Technologies Enjoy!


Everybody (Why Leave IIS?)

If you have gotten a chance to try an early build of SQL Server Reporting 2008 Reporting Services, you know that one of the changes in the product is the removal of the Internet Information Services (IIS) dependency. I have gotten some questions about the motivation behind this change so I thought I would give…


Younger Than Yesterday (ReportViewer in VS 2008)

As most of you probably know by now, Visual Studio 2008 is now available. What you might not have noticed is a new version of the ReportViewer control and local /embedded report editing experience. Included with VS 2008 are the following new features: Design-time:  New Report Projects: Two new project templates for quickly creating reporting…


Laser Guided Missiles (Report Localization through Parameters)

As localization is not a built-in feature for Reporting Services, people have tried a a variety of techniques for localizing reports. One technique is to use the LocID propertie to create a version of the RDL in each language. Another approach is to have a single report and create a custom assembly to load the…


Marquee Moon (Field References in Page Headers and Footers)

One of the questions that I get often is about putting database fields in their SSRS report page header and/or footer. Note that putting fields in the page header and footer is not the same as putting a data region in these sections. Because of the impact on layout (what happens when it grows?), we do…


Personal Best (The BI Survey)

Some of you may be familiar with Nigel Pendse’s OLAP Report. This year, the survey is broadening to include more BI functionality and is being renamed “The BI Survey”. If you have some time, take a moment and fill out the survey. We (and the other BI vendors) take the results seriously.


When I Was Born for the 7th Time (Thoughts from TechEd)

Last week I attended TechEd in Orlando, Florida. Here are my thoughts on the event. This year was TechEd’s 15th anniversary. I realized on the way down that I was attending my 10th consecutive TechEd. When I started attending, TechEd was about 2,000 or so people. This year, TechEd had over 13,000 people attending 480 Breakout…


Gone Glimmering (Fix for Visual Studio Hang)

I am very happy to announce that a fix has been released for the notorious “Visual Studio cannot shut down because a modal dialog is open” bug. I know that many of you are getting this daily when using the SQL Server 2005 Report Designer. You can read the KB article for the fix here. Currently, you will need…