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

rsWindowsIntegratedSecurityDisabled error when running Reporting Services report in SharePoint integrated mode

I published a report to SPS, using a custom data source which simply pointed to the database in...

Author: Russell Christopher Date: 02/09/2007

Reporting Services: Why aren’t all my report columns exporting to CSV and/or XML?

Don’t be surprised if reports exported to CSV or XML are missing several columns of data you...

Author: Russell Christopher Date: 02/07/2007

Reporting Services Login dialog appears when deploying to MOSS/WSS

Brian Welcker does it again! In this post he describes a situation that's been causing me a great...

Author: Russell Christopher Date: 02/07/2007

Can’t see “Reporting Services” on the SPS Application Management page after installing SPS/SSRS add-in

After installing the SPS/MOSS & SSRS integration add-in, I surfed to the Application Management...

Author: Russell Christopher Date: 02/03/2007

Mixed Bag: Troubleshooting Reports and Viewing MDX in Excel 2007

Just making note of two very worthwhile blog entries I've seen over the last few days. In this post,...

Author: Russell Christopher Date: 02/01/2007

Reporting Services and MOSS/WSS integration in a farm deployment

Now that SQL 2005 SP2 CTP3 supports installing SSRS on a different box than the MOSS/WSS machine,...

Author: Russell Christopher Date: 01/26/2007

Compress PDFs exported from the ReportViewer control

It's pretty common knowledge that when exporting a PDF from the ReportViewer control in local mode,...

Author: Russell Christopher Date: 01/24/2007

Publishing Reporting Services reports to MOSS

(Many, many thanks to Heidi Steen of the super-duper UE team at Microsoft for providing the material...

Author: Russell Christopher Date: 01/16/2007

Microsoft & Teradata to collaborate on BI solutions

http://www.microsoft.com/presspass/press/2007/jan07/01-15MSTeradataPR.mspx

Author: Russell Christopher Date: 01/16/2007

Reporting Services and MOSS SSO?

Now that SSRS can integrate with MOSS, I've started to see questions around whether one can use...

Author: Russell Christopher Date: 01/15/2007

Here's the RDL

Here's the RDL doc I couldn't attach to my previous post Report1.rdl

Author: Russell Christopher Date: 01/11/2007

Happiness is automatic SQL Reporting Services localization

Many people understand that you can leverage User!Language in order to grab the regional / language...

Author: Russell Christopher Date: 01/11/2007

Provisioning Shared Services is MOSS / SPS taking forever (my dumb mistake)

I just learned a hard, cruel lesson today. I’ve been trying to configure Shared Services on a MOSS...

Author: Russell Christopher Date: 12/21/2006

SQL Server 2005 SP2 CTP3 (December) is live!

CTP3 is now downloadable at:...

Author: Russell Christopher Date: 12/20/2006

Data Refresh in Excel Services fails with "SSO has failed with the following error code -2140995579, exception: Error in the application"

I've been playing quite a bit with Excel Services the last few weeks, and ran into a problem around...

Author: Russell Christopher Date: 12/19/2006

Custom Report Items not supported in SQL Express & Workgroup Editions

Saw an interesting conversation today around custom report items in SSRS. The information isn't a...

Author: Russell Christopher Date: 12/14/2006

A very cool (new) Report Designer from 90 Degree Software

I just finished watching an online demo of a great new Reporting Services report designer called...

Author: Russell Christopher Date: 11/22/2006

Exporting as PDF from Report Viewer control returns dramatically different file sizes

Here is an interesting tidbit I picked up today that concerns the Report Viewer controls. Mohammad...

Author: Russell Christopher Date: 11/14/2006

Confessions of a reformed SPS hater - MOSS and Microsoft Business Intelligence

OK, I admit it -- For years, I really didn't like SharePoint. I thought it was silly -- SharePoint...

Author: Russell Christopher Date: 11/03/2006

Saving SQL Server Reporting Services Reports inside MOSS

I spent this week "beta testing" a BI class that will soon be made available Microsoft partners and...

Author: Russell Christopher Date: 11/03/2006

Where are the @#!$!?*& Floating Headers in SQL Reporting Services?

I ran into this problem a few months ago and never figured out "why". However, a few days ago I saw...

Author: Russell Christopher Date: 11/03/2006

Reading the web.config file in SQL Reporting Services

The .NET Framework v2.0 gives us the ability to (easily) read the web.config file of our...

Author: Russell Christopher Date: 10/17/2006

Changing your gridsize in the SQL Reporting Services Report Designer

A customer asked exactly how one can change the default gridsize of 8 x 8 pixels to a different...

Author: Russell Christopher Date: 10/17/2006

Can't install SQL Reporting Services 2005 on Vista?

See this article: http://support.microsoft.com/kb/920201

Author: Russell Christopher Date: 09/25/2006

SQL Reporting Services and the Unattended Execution Account

Thanks to John Gallardo and Radu Grama for engaging in a very interesting conversation from which...

Author: Russell Christopher Date: 08/16/2006

Problems rendering Reporting Services reports with IE 7 Beta 3

There have been some internal discussions about IE 7 Beta 3 hanging while displaying SSRS reports,...

Author: Russell Christopher Date: 08/04/2006

Yummy Reporting Services / SharePoint Integration in SQL Server 2005 SP2

I attended TechReady3 last week, and one of the most interesting sessions focused on the work the...

Author: Russell Christopher Date: 07/30/2006

Reporting Services rendering performance improvements in Katmai

I'm attending TechReady3 (an MSFT technical training event), and just sat through a great session on...

Author: Russell Christopher Date: 07/27/2006

SQL 2005 Books Online refresh #3 and updated samples for July just released

BOL:...

Author: Russell Christopher Date: 07/21/2006

More fun with expression-based connection strings in Reporting Services

Books online has a good explanation of what you can do with expression-based connection strings in...

Author: Russell Christopher Date: 07/20/2006

Using a parameterized SSIS package as a data source for SQL Reporting Services

As you may know, SSRS reports can use Integration Services packages as a source of data. This...

Author: Russell Christopher Date: 07/19/2006

Unloading & Loading Reporting Services 2005 perfmon counters

If you need to unload and/or reload the SSRS 2005 perfmon counters for any reason, here's how: Use...

Author: Russell Christopher Date: 07/07/2006

Modifying label and tooltip text in the SQL Server Report Viewer controls (and a localization workaround!)

A while ago, I wrote a bit about how to localize the Report Viewer controls. You can find that...

Author: Russell Christopher Date: 06/07/2006

Where did "Select All" go in SQL Reporting Services 2005 SP1?

If you've installed SQL 2005 SP1 and use Reporting Services regularly, you've probably noticed...

Author: Russell Christopher Date: 06/06/2006

Unable to launch Report Builder from Report Manager when running Internet Explorer 7 Beta 2

After installing IE 7 Beta 2, I'm somewhat dismayed to find the Report Builder button in Report...

Author: Russell Christopher Date: 05/10/2006

SQL 2005 BOL Refresh 2 now available

http://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f&Di...

Author: Russell Christopher Date: 04/24/2006

"Internet Explorer cannot download " in Report Viewer controls

This week, I spent a fair amount of time dealing with a customer who had issues opening up SSRS...

Author: Russell Christopher Date: 04/21/2006

Microsoft accquires ProClarity!

http://www.microsoft.com/presspass/press/2006/apr06/04-03ProClarityPR.mspx

Author: Russell Christopher Date: 04/03/2006

Using SQL 2000 for SSRS 2005 metadata storage

When setting up SQL Server Reporting Services 2005, can you use SQL 2000 as the host for the...

Author: Russell Christopher Date: 03/29/2006

Using the XML Data Extension to leverage an ADO.NET dataset in your SQL Reporting Services Report.

Here's a quick walkthrough on how to return records in an ADO.NET dataset (via a Web Service) and...

Author: Russell Christopher Date: 03/24/2006

SQL Server 2005 Express Edition and Reporting Services -- At last!

Yesterday, Microsoft released the CTP of SQL Express with Advanced Services. You can use this distro...

Author: Russell Christopher Date: 03/21/2006

Good articles around using the ReportViewer control by Teo Lachev

Just stumbled upon two articles by Teo Lachev which provide an excellent overview of the...

Author: Russell Christopher Date: 03/20/2006

SQL Server 2005 SP1 CTP Available

See Brian's blog for into about the newly released SP1 CTP and what it means to SSRS users...

Author: Russell Christopher Date: 03/20/2006

Good post on Model Security

Bob Meyers posted a really good write-up on various ways to secure your report model!...

Author: Russell Christopher Date: 03/20/2006

SSL and SQL Reporting Services 2005

While setting up a Report Server to run with SSL, one of my customers repeatedly got the following...

Author: Russell Christopher Date: 03/06/2006

Using "Scale-Out" deployments In SQL Server Reporting Services 2005

Today I really played around with scale out deployments in 2005 (known as "reporting farms" in...

Author: Russell Christopher Date: 03/03/2006

Deploying a SQL Server Reporting Services 2005 report via an MSI

Most of the time, it’s acceptable for customers to deploy a report manually via Visual Studio,...

Author: Russell Christopher Date: 03/01/2006

Can’t see “Import Reports” in SQL Server Reporting Services Report designer

SSRS offers the ability to import Access reports via the Import Reports menu item off of the Project...

Author: Russell Christopher Date: 01/31/2006

Can I still download SQL Server 2000 Reporting Services even though 2005 has released?

There have been some questions about if / how / where you can get SSRS 2000 now that 2005 is upon...

Author: Russell Christopher Date: 01/31/2006

Yeah, yeah, it's not really BI -- Who cares

Today I couldn't register a new Notification Services App on my machine -- Try as I may, I got an...

Author: Russell Christopher Date: 01/24/2006

<Previous Next>