Russell Christopher's Semi-Useful BI Musings
This blog contains random one-off solutions to various problems I've encountered while using Microsoft's Business Intelligence tools SQL Server 2005 / Katmai
Changes in SSRS 2005 FindString HTMLViewer Command (URL Access)
In SQL Server 2000 Reporting Services, you could use the rc:Findstring command to find and highlight...
Author: Russell Christopher Date: 01/06/2006
I want to render HTML / RTF as HTML / RTF inside a SQL Reporting Services Report
Too bad. Many people have HTML and/or RTF stored in a database, a dataset, or wherever. If you...
Author: Russell Christopher Date: 12/14/2005
Updated SQL 2005 books online now available
Don't know how I missed this..this DL has been available for a week now!...
Author: Russell Christopher Date: 12/13/2005
Where are the Reporting Services samples in 2005?
You've installed SSRS 2005, and you're sure that you chose to include the sample files...yet you...
Author: Russell Christopher Date: 12/13/2005
The (un)official guide to SQL Reporting Services 2000 & 2005 interop
I've seen tons of questions around if you can use various components of SRS 2000 with SSRS 2005 (and...
Author: Russell Christopher Date: 12/13/2005
Creating a template report in SQL Reporting Services 2005
In SSRS 2000, there was a specific location on the filesystem where you could drop RDL documents so...
Author: Russell Christopher Date: 12/06/2005
Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider
I saw a question last week asking if one could use the new 2.0 SQLMembershipProvider to build a...
Author: Russell Christopher Date: 12/05/2005
Report Builder and Forms Authenticaton in SQL Server Reporting Services 2005
I've had a fair number of questions from my customers around the use of Forms Authentication in...
Author: Russell Christopher Date: 11/29/2005
SQL Express and SQL Reporting Services 2005 – Soon, but not yet
2005 Books Online and/or microsoft.com readers know that you can use SQL Express and SSRS together...
Author: Russell Christopher Date: 11/22/2005
(Almost) everything you need to know about the Report Viewer control in one place
This is the site of one of the ReportViewer PMs...lots and lots of juicy samples....
Author: Russell Christopher Date: 11/18/2005
Browsing Reporting Services 2005 Reports without IE for Windows
In 2005, there is limited report browsing support for non IE 6 SP1 browsers (IE 6 SP1 with scripting...
Author: Russell Christopher Date: 11/18/2005
SQL Server 2005 Samples and Sample Databases Available for DL
https://www.microsoft.com/downloads/details.aspx?FamilyID=e719ecf7-9f46-4312-af89-6ad8702e4e6e&Di...
Author: Russell Christopher Date: 11/18/2005
Impersonating another user with the Web Form Report Viewer control and SQL Server Reporting Services 2005
I covered how to do impersonation with the Winform ReportViewer control a few weeks ago, so here's...
Author: Russell Christopher Date: 11/18/2005
New Reporting Add-In for Microsoft Visual Web Developer 2005 Express
This one is flying under the radar -- Thought I'd publicize it a bit:...
Author: Russell Christopher Date: 11/17/2005
SQL Server 2005 Report Builder and Basic Authorization
I have a customer who needs to use Basic Auth with SQL Reporting Services 2005, so I wanted to make...
Author: Russell Christopher Date: 11/07/2005
Impersonating another user with the Windows Form Report Viewer control and SQL Server Reporting Services 2005
The Winform Report Viewer control is pretty nifty, but occasionally you'll want to access a remote...
Author: Russell Christopher Date: 11/05/2005
Using Forms Authentication with the Report Viewer control and SQL Server Reporting Services 2005
I've been playing around with using different forms of authentication / impersonation with the...
Author: Russell Christopher Date: 11/04/2005
Launching Report Builder from a Winform or Webform Application in SQL Reporting Services 2005
At times, you may need to launch Report Builder from your custom application as either the currently...
Author: Russell Christopher Date: 11/02/2005
Using a Report Builder Model as a Report Designer data source in SQL 2005
New in CTP16 / SQL Server 2005 Community Tech Preview (September) -- If you've spent a lot of time...
Author: Russell Christopher Date: 09/23/2005
Installing and Localizing the Visual Studio 2005 Report Viewer Controls
While playing around with the report viewer controls and localization, I bumped into a few things I...
Author: Russell Christopher Date: 09/21/2005
SQL 2005 CTP 16 is here
Want the next version of SQL 2005? Drive over here:...
Author: Russell Christopher Date: 09/14/2005
Fun with Date Functions in SQL Reporting Services Report Builder
Alec Harley reported an interesting (read: annoying) behavior around the use of Dateparts inside...
Author: Russell Christopher Date: 09/13/2005
Sharing Forms Authentication cookies in SQL Reporting Services
It’s not uncommon for someone to want to integrate their pre-existing ASP.net app (which utilizes...
Author: Russell Christopher Date: 09/08/2005
A couple of post IDW15 changes when building Report Builder Models in SQL Server Reporting Services 2005
While playing around with newer builds of Yukon, I noticed two changes from IDW15/CTP15 when it...
Author: Russell Christopher Date: 08/25/2005
2005 report farms and the Surface Area Configration tool. The horror! The horror!
I just spent an entertaining hour trying to get a 2005 Reporting Services web farm operational. It's...
Author: Russell Christopher Date: 08/23/2005
Tuning scheduled/delivery-related processes in a SQL Server Reporting Services Reporting Farm
[Thanks to Robert Bruckner, Daniel Reib, Tudor Trufinescu and Mike Schetterer!] Using rsConfig.exe...
Author: Russell Christopher Date: 08/17/2005
Random SSRS nuggets from all over
[This will be a list of resources I point people to all the time....just putting 'em all in one...
Author: Russell Christopher Date: 08/12/2005
Querying ExecutionLog in SQL Server Reporting Services: discretion is the better part of valor
I have to admit that I fairly regularly query the ReportServer..ExecutionLog table to look at the...
Author: Russell Christopher Date: 08/11/2005
Creating Report Subscriptions via SQL Managment Studio in SQL Server 2005
Just ran into an interesting little behavior in SQL Management Studio when I tried to create a...
Author: Russell Christopher Date: 08/09/2005
SQL Server Integration Services: Sometimes BCP is "good enough".
Today I sat in on a SSIS performance tuning "chalk talk" given by Ashvini Sharma at TechReady, an...
Author: Russell Christopher Date: 08/05/2005
Forms authentication and the ReportingService Web Service
After you've gotten the SQL Reporting Services Forms Authentication sample working, the next logical...
Author: Russell Christopher Date: 08/04/2005
Field Name Resolution in SQL Reporting Services 2005's Report Builder
If you've played around with Report Builder, you have probably used the Formula builder to modify an...
Author: Russell Christopher Date: 07/27/2005
Bet you don't know about these SQL Reporting Services perfmon counters
Thanks to Tudor Trufinescu and Matthew Hofacker for getting into a discussion on these suckers! As...
Author: Russell Christopher Date: 07/26/2005
Checking the version of Reporting Services you're running 2000/2005
I was suprised that I couldn't find a complete list of "build number to service pack" mappings for...
Author: Russell Christopher Date: 07/15/2005
Automatically refreshing your SQL Reporting Services reports with the AutoRefresh element
If want your report to auto refresh every x seconds inside IE, take a look at the AutoRefresh RDL...
Author: Russell Christopher Date: 07/13/2005
Multi-column interactive sort in SQL Reporting Services 2005
I've seen Brian Welcker (a group PM for SSRS - https://blogs.msdn.com/bwelcker/default.aspx) do a few...
Author: Russell Christopher Date: 07/12/2005
Is SQL Reporting Services 2000 / 2005 cluster aware?
I've asked this question myself, and seen lots of people do the same too...the answer is no. Neither...
Author: Russell Christopher Date: 07/11/2005
What to do after renaming your Report Server
Nothing earth shaking here. Just posting this so I can point others to the steps quickly. If you...
Author: Russell Christopher Date: 07/11/2005
How to hide items in the HTML Toolbar control for SQL Server 2000 Reporting Services
This is kind of old news since the feature has been around since SP1, but I haven't really played...
Author: Russell Christopher Date: 07/08/2005
RGDI and the Winform Report Viewer control in SQL Server 2005 Reporting Services
While playing around with report rendering in 2005, I noticed RGDI (for example, in CTP15 use Report...
Author: Russell Christopher Date: 07/07/2005
Good information on using the Report Viewer controls with SQL Reporting Services 2005
Author: Russell Christopher Date: 07/01/2005
"A data source instance has not been supplied for the data source" exception w/ Report Viewer Control
I'm using the webform Report Viewer control and I want to render a report locally on SQL Server...
Author: Russell Christopher Date: 07/01/2005
Report name with spaces and the ReportEmbeddedResource property of the Whidbey Report Viewer control
Ran into an interesting (and I guess understandable) behavior today while playing with the Visual...
Author: Russell Christopher Date: 06/29/2005
Displaying text vertically in SQL Server Reporting Services 2000
File this one under RTFM...but I had no clue even though it's right there in books online. Duh!...
Author: Russell Christopher Date: 06/28/2005
Displaying Report Builder to non-admin users in SQL Server Reporting Services 2005
I finally began playing around with how to secure models and/or items within a model, so I needed a...
Author: Russell Christopher Date: 06/27/2005
All about SQL Server Reporting Services 2000 Logs:
There are tons of logs in C:\Program Files\Microsoft SQL Server\MSSQL\Reporting...
Author: Russell Christopher Date: 06/26/2005
Another way to deal with defaults and snapshots in SQL Reporting Services
Here's an interesting scenario one of my customers had and how we approached it. The customer...
Author: Russell Christopher Date: 06/23/2005
How to preview a report without direct access to its data source in SQL Server Reporting Services 2000
You may have noticed that starting with SSRS SP1, when you preview a report which contains data in...
Author: Russell Christopher Date: 06/22/2005