AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Consulting
  • Courses
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Report De...
Change Colour (Colo...
 
Notifications
Clear all

Change Colour (Color) on a field based on data  

    Last Post
RSS

NickSM
Posts: 28
 NickSM
July 26, 2020 8:08 pm
(@nicksm)
21-50 Posts
Joined: 8 months ago

Hi,

 

I know that this is probably incredibly simple, but I am trying to work out the correct area and code to change the colour of data. I've looped in circle trying to find a blog page or anything but can't.

Super simple example. e.g If => $0.00 Black, if < $0.00 Red. How is this achieved and is it added in the Value section or Visibility? 

Topic Tags
report designer Colors
4 Replies
Ellie
Posts: 126
 Ellie
July 27, 2020 11:45 am
(@ellie)
101-200 Posts
Joined: 10 months ago

Are you referring to conditional formatting in the GI screen?

Here is a good article

 

Reply
NickSM
 NickSM
(@nicksm)
Joined: 8 months ago

21-50 Posts
Posts: 28
July 27, 2020 4:47 pm
Reply toEllieEllie

@ellie Unfortunately not. We are trying to do this in Report Designer only.

We can potentially do it using Visibility setting having one data field (Red) invisible and the another data field (Black) visible. We can then trigger it based on amount.

I thought that there might be a simpler way than that based on other report designer I've used in the past. Hey all Report Designers are equal 🤣 

Reply
Tim Rodman
 Tim Rodman
    ★★ All-Star ★★
(@timrodman)
Joined: 5 years ago

Over 200 Posts
Posts: 2488
September 22, 2020 1:20 am
Reply toNickSMNickSM
Ellie

@nicksm

Overlapping fields with different colors is the only approach that I can think of unfortunately. Acumatica Report Designer ain't Crystal Reports 🙂

Reply
NickSM
 NickSM
(@nicksm)
Joined: 8 months ago

21-50 Posts
Posts: 28
September 22, 2020 5:16 pm
Reply toTim RodmanTim Rodman
NickSM
Ellie

@timrodman

Thanks for that Tim and I think we did that in the end. Digital Metaphors Report Builder does the same thing as Crystal, so it's a case of searching for something you know.

Reply
Tim Rodman liked
  All forum topics
  Previous Topic
Next Topic  
Related Topics
  • Alternate ID Issue
    6 hours ago
  • Support for custom fonts
    1 week ago
  • Lot Numbers beside the Item Code
    3 months ago
  • Report from Inquiry Screen
    3 months ago
  • Customizing AP Checks
    3 months ago
Topic Tags:  report designer (34), Colors (2),
  Forum Statistics
11 Forums
1,656 Topics
7,693 Posts
2 Online
1,110 Members

Latest Post: Timecard reports/queries Our newest member: Janetteraab Recent Posts Unread Posts

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2021 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×