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
https://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
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
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: https://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
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
https://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!
https://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