Russell Christopher's Semi-Useful BI Musings

When setting up SQL Server Reporting Services 2005, can you use SQL 2000 as the host for the reportserver database? Yes, you can (with an obvious caveat in one scenario). How? Scenario 1: SQL Server 2000 currently is not running SSRS...

Here's a quick walkthrough on how to return records in an ADO.NET dataset (via a Web Service) and use them in a report. Many, many, many thanks to Ian Roof and Mary Lingel for forcibly pushing me in the right direction when I was clueless. First, here...

Yesterday, Microsoft released the CTP of SQL Express with Advanced Services. You can use this distro to get SSRS functionality in Express. Here's the section of the readme that applies to "us" (bold is mine): 4.2 Creating Reports by Using Reporting...

Just stumbled upon two articles by Teo Lachev which provide an excellent overview of the ReportViewer controls along with "real world" scenarios around how you can leverage them. The articles include some yummy sample code, too. Find them here: ...

See Brian's blog for into about the newly released SP1 CTP and what it means to SSRS users http://blogs.msdn.com/bwelcker/archive/2006/03/16/553262.aspx

Bob Meyers posted a really good write-up on various ways to secure your report model! http://blogs.msdn.com/bobmeyers/articles/Implementing_Data_Security_in_a_Report_Model.aspx

While setting up a Report Server to run with SSL, one of my customers repeatedly got the following error message: " The underlying connection was closed: Could not establish trust relationship with remote server ." The interesting thing was that...

Today I really played around with scale out deployments in 2005 (known as "reporting farms" in earlier versions) for the first time since I worked with them in 2000, and found an interesting behavior: I wanted to point my 2005 Enterprise Edition at...

Most of the time, it’s acceptable for customers to deploy a report manually via Visual Studio, Report Manager, or maybe by using an rss script. Last month I bumped into an organization that had a hard and fast rule that “anything deployable” (Winform...