Using Icons On Reports
  • 21 Jul 2023
  • 3 Minutes to read
  • Dark
    Light

Using Icons On Reports

  • Dark
    Light

Article Summary

Overview

The Color Rules feature empowers users to apply icons and colors intelligently and dynamically within Reports. This enables users to define complex logic, allowing the application of different icons to specific rows and/or columns within the Report based on pre-defined conditions.

Potential Use CasesDescription
Account Status Indicators
In financial services, Reports often display a multitude of accounts with varying statuses, such as active, pending, or closed. Financial institutions can strategically assign different icons to represent each account status by utilizing Color Rules. For example, an account eligible for online banking may be indicated by a checkmark icon, while a pending application may be marked with an hourglass icon, providing instant visual recognition of account statuses to bank staff and clients alike.
Risk Assessment Icons
Within financial analysis Reports, risk assessment is a crucial aspect. Financial analysts can implement icons representing different risk levels by utilizing Color Rules. For instance, a low-risk investment opportunity may be denoted by a green thumbs-up icon, while a high-risk investment is represented by a red caution icon. This feature allows stakeholders to quickly assess risk profiles, aiding in better decision-making and portfolio management.
Supply Inventory Management
Healthcare administrators can utilize the Color Rules feature to manage supply inventory efficiently. By assigning different colors to items based on stock levels, administrators can quickly identify critical supplies running low. For example, items with a red color could indicate low stock levels, prompting immediate reordering, while items with a green color signify sufficient stock.
Budgetary ControlAdministrators can leverage Color Rules to keep a close eye on supply expenditures. Depending on costs or budget allocation, different colors can be assigned to supply items. For example, high-cost items may be represented by red, drawing attention to potential budgetary concerns, while lower-cost items may have neutral colors.

Example

  1. In a Designer Project, create a Report. The example Report will use the Account Data Source. The Data Fields for the Report are Email Address and Is Active.
  2. Adjust the Report Grid View so the Icons will show up. Expand the Grid View section in the Properties panel. In the Grid Type drop-down, select Specified. This selection will provide additional options for configuring the Grid Settings. Selecting Specified also automatically adjusts the columns to their specified width; this can be adjusted within each Data Field Properties panel.
  3. From the Icon Type drop-down, select Image.

  4. In the Is Active Column Properties, expand the Colors and Icon section in the Properties panel and select 'Add New'.


  5. In the resulting dialog, locate the Rule Source drop-down, choose Icon Flow, then select 'PICK ICON FLOW'. Name the Flow, then select 'Create'.


  6. Below is an explanation of the Icon Flow logic and an accompanying video guide demonstrating the step-by-step process of building the Flow.
    Step NameInputs/Outputs
    Start StepSelect the Start step in the Flow Designer and open the Properties panel. Under Flow Data > Flow Input Data, click on 'Show Editor'.
    In the Data Definitions dialog, add "IsActive" and choose "Boolean" as the Type, then select 'Close'.

    Create Data Step

    Add a Create Data step from the Favorite Steps category. Click on 'Show Editor' for the Create Data step under Data Definitions. In the resulting dialog, create the Icon data. Name it "IconInfo" and select "ImageInfo" as the Type from the drop-down menu.

    Value Is True Step

    Add a Value Is True step by searching for 'Value Is True' in the steps toolbox. In the Properties panel under Inputs, select the Flow Input Data "CanUsePortal" for the Value.

    Create Data Steps (True and False Outcomes)

    Add two more 'Create Data' steps, one for the True outcome and another for the False outcome, from the Value Is True step. On the True path Create Data step, declare a variable of the type 'ImageInfo'. Set the input to constant and pick an image. Repeat the same steps for the Create Data step on the False path.
    On the output of both Create Data steps, set them to 'Change Value'. Map them to the IconInfo variable.
    End StepMap the 'IconInfo' variable to the 'Icon' variable.
    Save and close the Flow Designer. 
  7. Back in the Report Designer, select Update Inputs in the Add Colors and Icon Rules dialog. This will populate the Flow/Rule Inputs Data Grid; select the pencil icon next to the IsActive input.
  8. In the resulting window, in the Report Field drop-down, choose is_active and select OK. 
  9. The Report will now display icons according to the data within the specified column.
  10. Additionally, in the Column Properties, set the "Hide Column Text" to true to display the icon attached to the column. 

Was this article helpful?