RLDC Report Expression showing #Error

arvindas...

Sir

Greeting for the day

I am facing aproblem in report in asp.net c#.

I have below records in my query and Total is coming perfectly but when i want to take total of part seperate and labour it is showing Error.

I am using below formula in expression but report is showing #error

Please help me

=Sum(IIf(Fields!EntryType.Value="PART", Fields!Amount.Value,0))

dharmend...

0 1

Are there any NULL values in EntryType column?

Type casting needs to be done after IIF evaluates.

Expression:

=Sum(CInt(IIF(Fields!EntryType.Value="PART", Fields!Amount.Value, 0)))

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html