SQL Server 2016 – installation process notes

It is the usual thing in the tech world to start any product evaluation with the installation of the product and composing a blog post about the installation experience. We wait for new product releases, expect new awesome features and, sometimes, just “cannot wait”. I have been somewhat SQL Server addicted for a long time […]
Continue reading…

 

Interesting SQL Server Downloads – Week 13/2016

Microsoft gets faster and much more agile than before when it comes to interesting SQL Server downloads. There is no need to mention that many interesting tools and “side applications” will follow the announcement of SQL Server 2016. Here are just few I have spotted this week: *** Microsoft® SQL Server® 2016 RC1 Report Builder […]
Continue reading…

 

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…