Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Color text background in report 2009 style

Posted on by 1,867

Hi all

I 'm creating a report in ax2012 using report 2009 tool.

How can I set background color on a text?

I need to color red square, if you see on right image I set background color for a all text but when report is printed only where have text is color.

14607.1.png

I have try to create a square shape and set background color but the option doesn't exists.

85345.2.png

*This post is locked for comments

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    RE: Color text background in report 2009 style

    Hi Javier,

    Did you create the SSRS report based on a query or did you create a data provider with some logic? If you used the dat provider, can you possibly share your coding, so we can try to help improving the performance? E.g. did you use the 'insert_recordset' command or some loops with inserts in between?

  • Sukrut Parab Profile Picture
    Sukrut Parab 71,647 Moderator on at
    RE: Color text background in report 2009 style

    Cant you set color in control/text box properties using  report designer ?

  • XB Profile Picture
    XB 1,867 on at
    RE: Color text background in report 2009 style

    We run in a old version of Ax2012 and don't have warmup class.

    In ssrs report takes 10 minutos to display.

    The TimeDataRetrieval of repot is very big., I think the problem is all the groupings that the report has, I'm goint to try to avoid this.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    RE: Color text background in report 2009 style

    Hi Javier,

    What do you mean with "has reached 10 in the display"? Based on the type of report, you can actually put the report in a warmup class, so that caching had been done already which will also speed up the processing time.

  • XB Profile Picture
    XB 1,867 on at
    RE: Color text background in report 2009 style

    The only reason is performance.

    I have a class that takes a second to recover the data, when the report is shown with the SSRS report it usually takes 2 minutes and has reached 10 in the display.

    While with the 2009 tool it takes about 2 seconds to show up.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    RE: Color text background in report 2009 style

    Hi Javier,

    Do you have a specific reason why you create the report using the deprecated MorphX report tooling? The "AX2009" option was still available for migration purposes.

    Creating SSRS reports is the way to go forward. SSRS is able to fulfill this requirement.

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans