SQL Server Premier Field Engineer Blog

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

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

Enabling/Disabling Report builder 2.0 on SSRS 2008 in SharePoint integrated mode

Report Builder 2.0 on SQL 2008 and ClickOnce I have got the "how to enable Report builder 2.0 ClickOnce" question more than once and hence thought I would post it. In order to get Report builder 2.0 Clickonce,you need the New Sharepoint Add-in which was

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