Skip to main content

Notifications

Announcements

No record found.

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

Conditional Formatting in RDLC report layout in business central.

(0) ShareShare
ReportReport
Posted on by 153

Hi Guys,

For example : I want if my price are matches with selected price, then display red colour in price.

As shown below example.

i am writing below color expression but didn't get right result.

My matches value shows red color, but i want N/A value shows black color.

pastedimage1679888857970v3.png

pastedimage1679887746516v1.png

Is any way to do this.

  • Nilam Bhor Profile Picture
    Nilam Bhor 153 on at
    RE: Conditional Formatting in RDLC report layout in business central.

    Thank you

  • Suggested answer
    Vaishnavi J Profile Picture
    Vaishnavi J 3,056 on at
    RE: Conditional Formatting in RDLC report layout in business central.

    Hi Nilam,

    You can use the below expression in color section.

    =Switch(Fields!Price.Value=Fields!Selected_Price.Value,"Red",IsNothing(Sum(Fields!Price.Value)),"Black",Fields!Price.Value<>Fields!Selected_Price.Value,"Black")

    If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much.

  • Nilam Bhor Profile Picture
    Nilam Bhor 153 on at
    RE: Conditional Formatting in RDLC report layout in business central.

    I have already used that expression, but I didn't get right result.i.e.my N/A values are also coming in red color.

    I want only, if price & selected price values are matches then only, price values show in red, otherwise remaining price values display as a black color.

  • Sejal Profile Picture
    Sejal 95 on at
    RE: Conditional Formatting in RDLC report layout in business central.

    Hello Nilam,

    You use below Expression 

    =IIF(Fields!price.Value = Fields!SelectedPrice.Value ,"Red","Black")

    pastedimage1679907065788v1.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans