web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to eliminate 0 val...

Small and medium business | Business Central, N...

Suggested answer

How to eliminate 0 value in rdlc report layout

(0) Share

Report

Report

Posted on by Nilam Bhor

153

Hi Guys,

I want ,For example : In my selected price colums,i dont want 0 value in report,Instead of 0 ,i want to disply values like 100,200

I am writing below rdl expression, but didn't get output.

Is any way to do this

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

NAV_with_Narang 2,288 Moderator on at

Like (0)

Report

RE: How to eliminate 0 value in rdlc report layout

In the expression you need to use the expression code.BlankZero(Fields!MyField.value)

Helpful Blogs:

www.dynamicsuser.net/.../8

community.dynamics.com/.../print-blank-when-the-value-is-zero-in-rtc-reports

thinkaboutit.be/.../

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,553

#2

Sumit Singh 2,057

#3

YUN ZHU 1,915 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans