If Then Else in Report Builder 2.0 Expressions

: Joel Lipman; SQL Server Reporting Services; 06 May 2010; Hits: 37910

Yes, well don't laugh, I could not find this on the WWW so I was obviously not using Google properly. Anyway here's just a quick note on how to do if else statements in Report Builder 2.0

I'm looking at the following if statement:

copy raw

If (MyFieldName = 0) Then
     Return 1
Else
     Return MyFieldName

If (MyFieldName = 0) Then
Return 1
Else
Return MyFieldName

Can be expressed as:

copy raw

IIf(Fields!MyFieldName.Value = 0, 1, Fields!MyFieldName.Value)

IIf(Fields!MyFieldName.Value = 0, 1, Fields!MyFieldName.Value)

Category: SQL Server Reporting Services :: Article: 261

SSRS Report Builder 2.0 - Error during processing

: Joel Lipman; SQL Server Reporting Services; 06 May 2010; Hits: 13142

The Issue

After modifying a report and on running it, Report Builder 2.0 returns the following error:

An error occurred during local report processing.
An error has occurred during report processing.
Query execution failed for dataset 'DataSet1'.
The variable name '@GroupName' has already been declared. Variable names must be unique within a query batch or stored procedure.

Credit where Credit is Due:

Feel free to copy, redistribute and share this information. All that we ask is that you attribute credit and possibly even a link back to this website as it really helps in our search engine rankings.

Disclaimer: Please note that the information provided on this website is intended for informational purposes only and does not represent a warranty. The opinions expressed are those of the author only. We recommend testing any solutions in a development environment before implementing them in production. The articles are based on our good faith efforts and were current at the time of writing, reflecting our practical experience in a commercial setting.

Thank you for visiting and, as always, we hope this website was of some use to you!

Kind Regards,

Joel Lipman
www.joellipman.com

RSS Feed

Change Regional Settings for your Report (23636) Joel Lipman (SQL Server Reporting Services)
Basically I thought that the regional settings of a report generated using Report Builder 2.0 on a MS SQL Server 2008...
SSRS: Performance Improvements: SELECT TOP (9722) Joel Lipman (SQL Server Reporting Services)
What? This article details a method we used on a search form in a SQL Server Reporting Services (SSRS) environment....
SSRS Stop Scrolling Behind (7993) Joel Lipman (SQL Server Reporting Services)
Applies to: Microsoft SQL Server Reporting Services (SSRS) 2008 R2 Microsoft Visual Studio 2012 Microsoft Business...
SSRS Change Background Color of Image (12970) Joel Lipman (SQL Server Reporting Services)
What? Sounds easy but actually if you use an image which has transparent areas, ie. has one color which will be...
Room Availability Calendar in Business Intelligence Development Studio (11455) Joel Lipman (SQL Server Reporting Services)
Well I tried and I spent a few hours searching the net for a solution which displays the hours in the top columns, and...
SSRS Hide results table if empty (38744) Joel Lipman (SQL Server Reporting Services)
Update August 2011 So I don't know how many people were just saying why don't you do the following: Bring up the...
SSRS External Images don't display (53211) Joel Lipman (SQL Server Reporting Services)
The Situation We want some photos taken from another website of ours to display in our report. These are not stored...