Using Nz function in ASP.Net RDLC Report

makumbi
 
on Jul 22, 2022 12:58 AM
486 Views

Please help how can i use Nz function in RDLC

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

 

Download FREE API for Word, Excel and PDF in ASP.Net: Download
dharmendr
 
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.

Syntax

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)