The fix is to take the quotes off 0.00. Appears they were overriding the textbox properties.

If I try this -

=Sum(IIF(Fields!CL_DISADV_FL.Value = "N", "0.00", CDBL(Fields!CST_AMOUNT.Value)))

I get the following error -

Warning1[rsAggregateOfNonNumericData] The Value expression for the textrun ‘CL_DISADV_FL.Paragraphs[0].TextRuns[0]’ uses a numeric aggregate function on data that is...

Issue is resolved. Typo on my end with one of report item text boxes. Thanks guys and gals. Happy New Year.

It's trying to add 4 textboxes that will equal 100%.

It works great if I use the expression below, except when the value is zero. Then it comes up with NaN

=CDBL(reportitems!Textbox33.Value)...

With that I get a #Error in that field.

Warning1[rsRuntimeErrorInExpression] The Value expression for the textrun ‘Textbox204.Paragraphs[0].TextRuns[0]’ contains an error: Input string was not in a correct format.

Yes that is because it equals zero

Good to go. The properties in the report header parameter, rather than the parameter properties in the toolbox on the left. Brilliant. Thanks as always.

MC

No. I mean that would be great but perhaps a little overkill. The parameter is just pasted on the report header so it shows the user what project they have...

I setup the parameter default values with the expression below:

=UCase(Parameters!Project.Value)

I am getting the following error:

"The DefaultValue expression for the report parameter 'Project' contains and error: The expression references the parameter...

Or is it easier to create the function in SSRS report parameter properties ?

Brilliant. Thanks so much. I have a stored proc that the report calls. How can I integrate that CASE code into the PROC below:

USE [WEBAPP_CP]

GO

/****** OBJECT: STOREDPROCEDURE [DBO].[RPT_VENDOR_ACTIVITY_BY_EEOC] ...

The total for VID '123' with a VNO '2' should equal 100.00

The total for VID '123' with VNO '324' should equal 1101.00 (103.00 + 102.00 + 325.00 + 416.00 +...

Apologies Ninja Warrior. I'll work on getting it in a better format for the pros.

Just as you were typing, I wrapped the date in quotes and bam, it worked. Thanks again!

INVC_DT (smalldatetime, null)