Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

showing text colorful in Report

(0) ShareShare
ReportReport
Posted on by 3,084

Hi Experts,

A requirement was given to me that is develop a report on condition based as example let say value is up than 1000 it shows that up than 1000 in red color(text). Is it possible.

Thanks and Regards,

Shabir Ahmad

  • Alfasith AX Profile Picture
    Alfasith AX 120 User Group Leader on at
    RE: showing text colorful in Report

    Hi Shabir,

    =iif(Sum(Fields!AcquisitionY3.Value, "FAAcquisition") >1000,"Black","LimeGreen")

    Select filed color properties of the text box and follow this, If you need to change the color double click on respective color, text will appear.

    alfasith.blogspot.com/.../alternative-color-in-ssrs-2012.html

    pastedimage1604393072004v1.png

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: showing text colorful in Report

    Good morning Shabir,

    Have you been able to get your report completed with the colorful text?

    Would be great if you could let us know if any other help/information is needed.

    Best regards,

    Ludwig

  • Blue Wang Profile Picture
    Blue Wang on at
    RE: showing text colorful in Report

    Hi Shabir,

    Open the text box properties and add expressions under the Color property

    3058.PNG

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: showing text colorful in Report

    Hi Shabir,

    I am not a developer and can't thus help much.

    Yet, I did some searches and found some sites that might give you some ideas how to get started with the color stuff.

    Please see:

    community.dynamics.com/.../how-to-highlight-color-in-ssrs-report-in-ax

    axaptaworld-saklani.blogspot.com/.../change-row-color-in-ssrs-reports-ax2012.html

    www.tutorialgateway.org/.../

    Hope this helps.

    Best regards,

    Ludwig

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,084 on at
    RE: showing text colorful in Report

    Hello Dr.Luidwing Reinhard,

    Yes, this  SSRS Report i am developing as a requirement.

    Best Regards,

    Shabir Ahmad

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: showing text colorful in Report

    Hello Shabir,

    Is the report that you refer to a SSRS report or one that you create in the Management Reporter?

    In the Management Reporter you can color your amounts, lines and columns as needed out of the box without making a modification.

    For SSRS reports, have a look at what Sergei shared.

    Best regards,

    Ludwig

  • Suggested answer
    Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,089 on at
    RE: showing text colorful in Report

    Hi Shabir,

    It should be possible with HTML expressions

    www.sqlchick.com/.../using-different-formats-within-a-single-textbox-in-ssrs.html

    www.w3schools.com/.../tag_font.asp

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans