Share via


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

[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

https://whidbey.msdn.microsoft.com/library/?url=/library/en-us/rs_vsrpts/html/0334cfba-2cb7-4d8b-8927...

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

<Previous Next>