CODEWITHSUNDEEP
c#visual-studio-2012reporting-services
LittleBirdy
LittleBirdy

Reputation: 499

Datatype missmatch with Running Value function in SSRS

I have an expression: 

=RunningValue ( CInt(Fields!Quantity.Value) * CInt(Fields!Vol.Value),SUM, Nothing)

Initially I haven't added CInt , but I suspect the data type missmatch issue, so I tried adding with it.

In SQL side, both of these are Int type.

But, inside my deployment environment, it still showing #Error. I have no idea how to correct it. Kindly help, please. Thanks

Upvotes: 0

Views: 173

Answers (1)

BIDeveloper
BIDeveloper

Reputation: 2638

Check for nulls.

I'm guessing you have null values coming back. Use the IsNothing function.

e.g. IsNothing(yourFieldValue,0)

Upvotes: 1

Related Questions