Russell Christopher's Semi-Useful BI Musings

New in CTP16 / SQL Server 2005 Community Tech Preview (September) -- If you've spent a lot of time building the perfect model for use by Report Builder, you may want to use it as a data source for any reports you build with VS Report Designer, too. ...

While playing around with the report viewer controls and localization, I bumped into a few things I think are worth passing along. In the "I should have known this in the first place" department, you must take steps to make sure the report viewer runs...

Want the next version of SQL 2005? Drive over here: http://www.microsoft.com/sql/2005/productinfo/ctp.mspx

Alec Harley reported an interesting (read: annoying) behavior around the use of Dateparts inside date-related functions used by Report Builder In older builds, it appears you may not use the nice abbreviated Dateparts that we're used to (for example...

It’s not uncommon for someone to want to integrate their pre-existing ASP.net app (which utilizes Forms Authentication) with Reporting Services. When doing so, we don’t want to force users to logon twice, however – The goal is to have the Forms auth cookie...