Sum of a SQL Analysis Services calculated measure within a Reporting Services report gives #Error

Summing a SQL Analysis Services calculated measure result within a Reporting Services report gives #Error but the same calculated measure output can be summed within Analysis Services perfectly fine. Environment: SQL Server 2008 Analysis Services and Reporting Services + SP1, Report builder 2.0 sp1. This should be applicable to all SQL 2008 and 2005  Reporting…


Possible performance implications when using string parameters in Reporting Services

In Reporting Services String Parameters are of type Unicode. This could have unwanted side effects if comparing with a varchar ( or non-unicode data type) on the data source due to conversions that could occur from the non-Unicode column to the Unicode column as the resulting query plans may use scan’s instead of seeks. This…


Chart behavior difference in SQL Reporting Services 2008

There are some changes in behavior in Reporting Services Charts with regards to “Empty Points” between SQL 2005 and SQL 2008  (http://msdn.microsoft.com/en-us/library/dd207051.aspx) Let us consider the following Dataset: create table #TestChart (   Runtime datetime,   SensorReading int,   SensorName varchar(20) ) insert into #TestChart values(‘2009-01-30 1:30:00′,165,’SENSOR_A’) insert into #TestChart values(‘2009-01-30 1:31:00′,145,’SENSOR_B’) insert into #TestChart…