mrc logo mrc logo
  • m-Power m-Power
    What is m-Power?
    Overview Demos Build Process Case Studies Specs Pricing Trial
    m-Power Resources
    Overview How-To Videos Webinars & Podcasts White Papers Fact Sheets
  • Solutions Solutions
    What does m-Power build?
    Overview Database Front-Ends Reporting CRM Systems Business Intelligence Dashboards Inventory Management Mobile Apps ERP Enhancements Modernization Spreadsheets to the web MS Access to the web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Data Exploration Budgeting & Forecasting APIs and Web Services Db2 Web Query Alternative
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Development Services Training Mentoring
  • About About
    Overview Partners Press Releases Careers Events Contact Blog
  • Support Support
    Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • m-Painter
  • Color Coding via m-Painter
Back to Manual

Color Coding via m-Painter

Click here to view documentation for the current version of this feature.
To help highlight data patterns, developers often employ the use of conditional styles to color code their data. For example, when a percentage is greater than 80%, you may wish to make that data cell green, whereas otherwise you would want to continue to leave it as a white background with black text.

Color Coding Demonstration

m-Painter allows you to add color coding to your data set in the following methods:


  • By color coding the individual cell/row across all templates
  • By color coding the entire column (Reports only)
  • Color Coding the Cell/Row

    To begin, right click the cell you wish to color code, then place your cursor over the "Cell" context option, and select "Color Code Cell".

    You will be brought to a screen that looks like this:

    Utilize the condition area to specify the rules for your condition. In the "Value Field/Text" input box you can either specify a hard-coded value (via the "Text" option) or compare two fields to one another (via the "Field Value" option). By clicking the "Add Another Case" button, you can add additional conditions to this rule.

    The next step, is to specify either a CSS Class or a CSS Style. If you have a pre-made CSS class you wish to use, please enter it in the "CSS Class Name." If not, toggle to the "Set CSS Styles" tab and enter in the rules you wish your condition to use.

    When finished, be sure to click "Save Condition" button. If you wish to have multiple color condition rules on one cell, feel free to add additional conditions within this same wizard. When completed, be sure to press OK to close the wizard.
    In the below example, I have created 3 rules depending on the value of my "Runs" field value.

    In m-Painter, I can see this individual cell has color coding on it, as a thicker border is now drawn.

    Note: This border is only visible in m-Painter and will not be seen by the end-user.

    At run-time my application looks something like this:

    Note: While not explicitly stated above, the same process could be employed by row so that your conditional logic is applied to all cells within a row by right clicking on a cell, hovering over Row, then choosing the "Color Code Row" option.

    Color Coding the Entire Column with a Report

    Report templates are unique in that they display multiple levels of output depending on selected subtotal and grand total levels. If you were interested in creating a conditional rule that applied to all rows for a given column, first right click one of the cells within the column you wish to color code, then place your cursor over the "Column" context option, and select "Color Code Column".

    You'll notice that you now have the ability to select the "From" location of your selected field. The purpose of this option is to allow you "from" where you would like the data accessed for your conditional logic. Specifically, since you are working across multiple levels, be sure to select either "Subtotal" or "Last Row of Detail", depending on how you want your totaling levels to be computed — when the color conditioning is processed for the detail level, it will automatically utilize the data from the row level.

    As an example, see how I have configured my column to print a yellow background when the value from field "Issues- this period" is greater than the value from field "Receipts- this period". Be sure to press "Save Condition" prior to pressing "Ok."

    In my output below, you can see how my color logic was applied to all levels.

    Color Coding with the OLAP Pivot Table Report Template

    The OLAP Pivot Table template supports color coding as of the January 2015 release of m-Power.

    Click the Color Code icon in the Insert tool menu to add a new color condition.

    m-Painter will display a list of saved conditions at the bottom of the page. To edit a saved condition, place your cursor over the desired condition and right-click. Select Insert/Edit Color Condition.

    Note: Color coding dimension fields is not supported in the OLAP Pivot Table template. You may only set conditional coloring for value fields.

    Other Important Details….

  • To delete an individual condition, click the "Remove" link. However, if you wish to delete the entire entry, click the "Remove Existing Color Code Condition" checkbox at the top of the dialog window, then press "Ok."
  • The color conditional logic is not designed to have multiple rules applied to the same cell. For instance, do not attempt to apply one rule to an individual cell, then a separate rule applied to the entire row.
  • This feature is not supported in applications where the run time property "Column Reorder" has been enabled.
  • Created: July 7, 2014 | Modified: November 16, 2023

    Search


    Browse By Category

    Build Process (13)
    Starting with m-Power (8)
    Retrievals (10)
    Reports (15)
    Summaries (4)
    Maintainers (17)
    Graphs (8)
    m-Power Data Explorer (4)
    General (24)
    Calculations (5)
    Utilities (9)
    m-Power Administration (23)
    Security (11)
    Freemarker (6)
    m-Painter (29)
    Form Validation (5)
    External Objects & UDFs (12)
    Deprecated Documentation (23)
    Bootstrap Templates (7)

    Popular Tags

    Maintainer Email Graphs SQL Dates Video Graphing Advanced Excel Administration Record Selections RPG Prompt Screens DB2 Reports Dropdowns Build Process Freemarker Retrievals mrc-Productivity Series Bootstrap Templates App Properties Admin Getting Started Parameters Maintainers Report Data Dictionary Graph Properties Security m-Painter Popular Summaries Production Compiling Retrieval Application Properties Form Validation Java Bar Graphs Database External Objects Tomcat Performance Calculations

    See all tags »

    michaels, ross & cole, ltd. (mrc)

    Privacy Policy Cookie Policy Cookie Settings Notice at Collection Do Not Sell or Share My Personal Information

    mrc (US)

    2001 Midwest Road
    Suite 310
    Oak Brook, IL 60523
    630-916-0662

    mrc (UK)

    Mortlake Business Centre
    20 Mortlake High Street
    London, SW14 8JN
    +44-20-335-59566


    © 2024 mrc. All rights reserved.