CODEWITHSUNDEEP
reporting-servicesssrs-2012
ngoc
ngoc

Reputation: 63

SSRS expression on textbox got error when run report

I have table name SeviceFeeSummary with decimal field name SeviceFeeTotal (data example 3123.4512)

On SSRS report, I create text box with expression 

=Sum(Fields!servicefeetotal.Value, "SeviceFeeSummary")

and 

=First(Fields!servicefeetotal.Value, "SeviceFeeSummary")

I got error return when run report. Please help to see what went wrong with these expression. Thank you so much.

Upvotes: 0

Views: 1181

Answers (2)

Strawberryshrub
Strawberryshrub

Reputation: 3389

You cant reference to a table or tablix name (SeviceFeeSummary) in your SSRS expression. The scope is just for dataset names or group names:

=Sum(Fields!YourField.Value, "DatasetName")
=Sum(Fields!YourField.Value, "GroupingName")

And try using a tablix and not a textbox.

Upvotes: 1

Ross Bush
Ross Bush

Reputation: 15175

It appears you are using a Case other than what the field bound to the dataset is using. Also, remove the SUM() expression to rule out datatype mismatch.

Try this-->

First(Fields!ServiceFeeTotal.Value, "SeviceFeeSummary")

Upvotes: 0

Related Questions