How to convert 0.00 value to nill in ssrs report

Ranchoo424 · April 23, 2014, 7:19am

This is my report design. In the field excise duty if there is any amount it is coming if there is no amount by default it is coming 0.00 my requirement is how to show that value 0.00 to nill

please help me

give reply

R.K.M POWERGEN PVT. LTD.
Goods Receipt Note(GRN)

Suppliers Name

G.R.N. NO.

45646

GRN DATE

22 Apr 2014

AXON

INWARD NO

INWARD DATE

Old No. 124,New No. 18,Virudhunagar,

CH. No

768

CH. Date

22-04-2014

Virudhunagar

LR. No.

8769679769

LR Date

22-04-2014

INVOICE NO

INVOICE DATE

626 125

VEHICLE NO

7877

TINNumber:12345678910

PO No.

RKM-000554

PO Date

22-04-2014

Sl.No

Description

UNIT

INV. Qty

Acpt. Qty

Rate

Amount

Valuation

1

SAN

g

10.00

₹1000000.00

₹100,00,000.00

Total

₹100,00,000.00

Exice Duty

₹0.00

Freight Charges

Grand Total

₹100,00,000.00

Amount In Words Rs: Ten Million and Zero paise Only

sumit_samal · April 23, 2014, 7:33am

Hi Ranchoo,

Go to Amount field Expression and write the exp

I Hope it will work

=iif(Fields!Amount.value = 0," Nill",Fields!Amount.value)

Best Regards

Sumit

Ramank · April 23, 2014, 7:49am

HI Ranchu,

You can achieve this one using expressions.

Refer sumit suggestion:

Go to Amount field Expression and write the exp

I Hope it will work

=iif(Fields!Amount.value = 0," Nill",Fields!Amount.value)

Thanks & Regards,

Raman Kutala.

Ranchoo424 · April 23, 2014, 1:12pm

In my report i changed grand total field expression like

=sum(Fields!ParmLineAmount.Value)+Fields!TotalAmount.Value

it is working & grand total is coming

but how can i display it in words