Using Nz function in ASP.Net RDLC Report

on Jul 22, 2022 12:58 AM

Please help how can i use Nz function in RDLC



Download FREE API for Word, Excel and PDF in ASP.Net: Download
on Jul 22, 2022 01:07 AM

Hi makumbi,

You can use the Nz function to return zero, a zero length string, or another specified value when a Variant is Null.


Nz(variant [,valueifnull])

variant : Required. A variable of data type Variant.

valueifnull :Optional

So the Expression is like below.

=Nz([4], 0)+Nz([5], 0)+Nz([6], 0)+Nz([7], 0)+Nz([8], 0)+Nz([9], 0)