SSRS: How to fix rsInvalidDataSourceReference

I was analyzing my blog stats today and noticed that really a lot of people land at my old blog post about fighting with rsInvalidDataSourceReference in System Center Operations Manager environments. As far as I understand, that is not exactly what most of the SSRS guys are looking for.
I decided to fix this, so please find below my explanation of the nature of rsInvalidDataSourceReference. First things first, what is the Data Source, what is Reference and why is it Invalid?..
Continue reading…

 

Configure SQL Server Business Intelligence Development Studio 2008 to support OpsMgr reports development

Update: Instructions for SQL Server 2012 Data Tools are here. This is just a short note on how to configure BIDS 2008 to support OpsMgr reports development. Copy Microsoft.EnterpriseManagement.Reporting.Code.dll from SSRS bin folder to C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ Add ManagementGroupId key to devenv.exe.config: just copy <appSettings>…</appSettings> section from your ReportingServicesService.exe.config like this: <configuration> … <appSettings> <add key="ManagementGroupId" […]
Continue reading…

 

SSRS 2008 in backward compatibility mode: conditional visibility doesn’t work

Couple of months ago I blogged about conditional formatting. Now it turned out that conditional visibility doesn’t work as well. Here is the case: You design report which has a list with nested table; You use expressions to manage columns visibility; Outcome: Everything is okay in SSRS 2005 Everything is okay in SSRS 2008 running in “native” […]
Continue reading…

 

Conditional formatting doesn’t work if report is processed by SSRS 2008 (SP1 or SP2) in backward compatibility mode.

Pretty long  title, isn’t it? But the story is short. I was authoring an OpsMgr report containing custom control designed for SSRS 2005 (EnterpriseManagementChartControl – shipped by Microsoft with OpsMgr and is used by MS Generic report library) and some conditionally formatted table cells (background color, text color and font weight). Guess what I’ve got […]
Continue reading…

 

InteractiveHeight, SSRS 2005 rdl schema and an instance of SSRS 2008

Got an awesome bug yesterday. QA guys reported that when they had tried to deploy my reports MP to OpsMgr installation powered by SSRS 2008 SP1, they got the following error: Failed to deploy reporting component to the SQL Server Reporting Services server. The operation will be retried. Exception ‘DeploymentException’: Failed to deploy reports for […]
Continue reading…