Russell Christopher's Semi-Useful BI Musings

I published a report to SPS, using a custom data source which simply pointed to the database in question and used Integrated Security. When I ran the report, the following error was thrown: An error has occurred during report processing (rsProcessingAborted...

Don’t be surprised if reports exported to CSV or XML are missing several columns of data you otherwise see when viewing the report as HTML, PDF, etc. PDF, HTML, and Excel export leverage “layout renderers” – a generally more expensive export process...

Brian Welcker does it again! In this post he describes a situation that's been causing me a great deal of angst. Essentially, after getting MOSS/SSRS integration working, you get prompted to login when publishing from BIDS - and entering credentials doesn...

After installing the SPS/MOSS & SSRS integration add-in, I surfed to the Application Management page of SPS…and no “Reporting Services” list was apparent. So, I used some information at Brian Welcker’s blog and took a look through all of the rs_sp_...

Just making note of two very worthwhile blog entries I've seen over the last few days. In this post , Lukasz Pawlowski provides us with a nice top-to bottom SSRS troubleshooting approach with links to additional information on most troubleshooting...

Now that SQL 2005 SP2 CTP3 supports installing SSRS on a different box than the MOSS/WSS machine, people have been bumping into problems getting everything working properly. After installing / configuring, common error messages you may see are: ...

It's pretty common knowledge that when exporting a PDF from the ReportViewer control in local mode, you get a much larger document back then if the same report was exported via the ReportServer web service. I wrote a little entry about same here . ...

(Many, many thanks to Heidi Steen of the super-duper UE team at Microsoft for providing the material below. Hell, she even created screen shots!) Now that lots of folks are happily playing around with SSRS/MOSS integration, it’s important to understand...

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

Now that SSRS can integrate with MOSS, I've started to see questions around whether one can use SharePoint single sign on with Reporting Services. Short answer: No. If you'd like the feature added to a future version of the SSRS add-in for MOSS...

Many people understand that you can leverage User!Language in order to grab the regional / language settings of a user, then use this information to localize your report data & label text. If you don’t, no worries. Check this topic out: http:/...

I just learned a hard, cruel lesson today. I’ve been trying to configure Shared Services on a MOSS machine, and I found that once I started the process, it would run for 60+ minutes without completing. Checking in the Shared Services window of Central...

CTP3 is now downloadable at: http://www.microsoft.com/downloads/details.aspx?familyid=D2DA6579-D49C-4B25-8F8A-79D14145500D&displaylang=en#QuickInfoContainer As far as reporting-heads are concerned, CTP3 is good for us because it removes the...

I've been playing quite a bit with Excel Services the last few weeks, and ran into a problem around refreshing data in a worksheet stored in Excel Services when I used Single Sign On (SSO) in the ODC. I also noticed that each time my report failed...

Saw an interesting conversation today around custom report items in SSRS. The information isn't a huge surprise, but at the same time is not documented in books online, either: Custom report items will only work inside Standard | Developer | Enterprise...

I just finished watching an online demo of a great new Reporting Services report designer called "Radius". It's a new report designer created by the folks at 90 Degree Software, and I think it’s going to be a home run. It has a number of things going...

Here is an interesting tidbit I picked up today that concerns the Report Viewer controls. Mohammad Farooq, one of our fine support folks, noticed that the same report exported as PDF from our Report Viewer control was a different size depending on...

OK, I admit it -- For years, I really didn't like SharePoint. I thought it was silly -- SharePoint sites were things that people started on a whim (like those "blog whatchamacallits") and then quickly abandoned. Collaboration? Yeah, whatever -- just attach...

I spent this week "beta testing" a BI class that will soon be made available Microsoft partners and those who want to develop on our platform. I was quite impressed by the material and instructors -- If you hear about and/or have the opportunity to attend...

I ran into this problem a few months ago and never figured out "why". However, a few days ago I saw a discussion that clued me in. Anyway, the HTML Toolbar (the thinger that allows you to do paging, searching, exporting, etc. in your reports) is responsible...

The .NET Framework v2.0 gives us the ability to (easily) read the web.config file of our applications for information like <appSettings> using the System.Configuration and System.Web.Configuration namespaces: This probably isn't news to most of...

A customer asked exactly how one can change the default gridsize of 8 x 8 pixels to a different value in order to make it easier for him to move and place small ReportItems on the design surface. I had no clue! VS gives you some options for a Windows...

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

Thanks to John Gallardo and Radu Grama for engaging in a very interesting conversation from which I’m cribbing the following information! Scenario: After changing the password on the user you are using for SSRS’s unattended execution account, all...

There have been some internal discussions about IE 7 Beta 3 hanging while displaying SSRS reports, and Lukasz has a write-up on same. Long story short, sounds like Beta 3 won't play with SSRS nicely. http://blogs.msdn.com/lukaszp/archive/2006/07/12...