News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to write condition...

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

Answered

How to write condition in Excel report using excel buffer in business central

(0) Share

Report

Report

Posted on by Nilam Bhor

153

Hi Guys,

I want to write a condition on excel report using excel buffer.

I have create on excel report using excel buffer.In that report there is 3 columns.

In amount column ,I want to display condition: if amount is 0 then display 'No balance' text in report.

i.e. Column C - Amount (If Amount is 0, then display 'No Balance' instead of 0.)

Is any way to do this

Categories:

Business Central

All responses Img

All responses (2)

Answers Img

Answers (1)

Suggested answer

YUN ZHU 73,647 Super User 2024 Season 2 on at

Like (0)

Report

How to write condition in Excel report using excel buffer in business central

Hi, or you can use the Format method to convert all the amount into text, and then modify the format uniformly in Excel.

Hope this helps as well.

Thanks.

ZHU
Verified answer

TeddyH 12,868 Super User 2024 Season 1 on at

Like (0)

Report

How to write condition in Excel report using excel buffer in business central

Add if condition after the amount calcfields. Example:

"Cust. Ledger Entry".CalcFields(Amount);

if Amount = 0 then

Rec_excelbuffer.AddColumn('No Balance', true,'',true,false,false,'',Rec._excelbuffer."Cell Type"::Text)

else

Rec_excelbuffer.AddColumn('Amount, true,'',true,false,false,'',Rec._excelbuffer."Cell Type"::Number);

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans