• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1486
  • Last Modified:

SSRS Expression error

I get the error
"The value for the expression textbox contains an error [BC30452] 'is not defined for types Microsoft.ReportingServices.ReportingProcessing.ReportObjectModel.Field' and Integer
for the following code in my expression
=IIF(not(isnothing(fields!MonthSales1)) and not(isnothing(fields!MonthSales1_LY)) and fields!MonthSales1_LY > 0,fields!MonthSales1/fields!MonthSales1_LY -1, 0)
=IIF(not(isnothing(fields!MonthSales1))and not(isnothing(fields!MonthSales1_LY)) and fields!MonthSales1_LY <= 0,fields!MonthSales1/fields!MonthSales1_LY -1, 100)

Basically I think the problem is that fields!MonthSales1_LY is null sometimes so when I try to set it greater than 0, I get the error.  I am used to doing this with nested ifs in other packages, but am not how to in SSRS.
0
sbdt8631
Asked:
sbdt8631
1 Solution
 
Nico BontenbalCommented:
fields!MonthSales1 refers to the field, which is an object. Not the value of an object try using:
fields!MonthSales1.Value
instead.
0
 
sbdt8631Author Commented:
Oops
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now