Meta
Archives
Categories
Tags
Architecture Biking BizTalk C# DataWarehousing DBA Denali IFR IIS IoC Learn To Fly Legacy log4net MadDotNet MadeInUSA MSTechEd MVC MVVM NHibernate ORM PDC PowerPivot Racing RFID SharePoint SilverLight Sql SQL Server 2012 SSAS SSIS SSRS Tabular Models Team Build Team Foundation Server Testing Triathlon Virtualization Visual Studio WCF Windows Server WPF
Tag Archives: SSRS
SSRS: Checking for Divide By Zero Using Custom Code
I encountered a divide-by-zero error while working on an SSRS report and thought the issue could easily be resolved using IIF with code similar to the following: =IIF(Fields!Denominator.Value = 0, 0, Fields!Numerator.Value/Fields!Denominator.Value) I soon realized that this does not resolve … Continue reading
SSRS: Lookup Functions
There are three lookup functions in SSRS 2008 R2: Lookup, LookupSet and MultiLookup. Lookup The lookup function compares a value in the current scope to a value in a destination dataset and returns a single value from the destination dataset … Continue reading
SSRS: Multi-Value Parameters and NULL values
In SSRS, multi-value parameters cannot contain null values. If you create a multi-value parameter in SSRS and check the option “Allow null value”, the following error message is displayed. I recently encountered a scenario where I wanted to include a … Continue reading
SSRS: Shading part of a chart area using Report Builder 3.0
If you need to fill part of a chart area with a specified color (e.g. to highlight an acceptable range of values) one way to accomplish this task is to add an additional series. In this example, all values less … Continue reading
Custom Assemblies in Sql Server Reporting Services 2008 R2
Overview In SQL Server reporting services, you can write custom code in two ways. The first is to embed VB.net code directly into the report. The second is to create a .Net assembly in C# or VB.net and deploy this … Continue reading