Icons in Tempo Report

Question

Hello, I have a tempo report with a grid that show the data of a process getting them from a datastore, in this data store there are two field (ManagerApproval and RequestStatus) of type Number Integer. Now in the report the value of this column are number and the possible values are null, 0, 1, 2 I already have various constant of type document called: -ICON_GREY_GLASS, with value a .gif file -ICON_RED_ALERT, with value a .gif file -ICON_YELLOW_GLASS, with value a .gif file -ICON_GREEN_GLASS, with value a .gif file and the following expressione rule: = if ( ri!value = "" , cons!ICON_GREY_GLASS , if ( ri!value = 0 , cons!ICON_RED_ALERT , if ( ri!value = 1 , cons!ICON_YELLOW_GLASS , cons!ICON_GREEN_GLASS ))) For portal reports we use this rule to convert the number integer to the corresponding image icon. There is a similar way to do so for Tempo reports? I've seen the a!iconIndicator function,... 
 OriginalPostID-203564 
 OriginalPostID-203564

marcoc918 · Accepted Answer

Thank you for all your help.

To solve this problem I've followed this method:

I have created the following expression rule called "ApacMobileConvertStatusManagerToLight":

if(ri!statusManager="",
a!documentImage(
document: cons!ICON_GREY_GLASS,
altText: "Not Started",
caption: "Not Started"),
if(ri!statusManager=0,
a!documentImage(
document: cons!ICON_RED_ALERT,
altText: "Rejected",
caption: "Rejected"),
if(ri!statusManager=1,
a!documentImage(
document: cons!ICON_YELLOW_GLASS,
altText: "In Approval",
caption: "In Approval"),
a!documentImage(
document: cons!ICON_GREEN_GLASS,
altText: "In Approval",
caption: "In Approval")
)
)
)

and in the report dashboard I have used this code:

a!gridImageColumn(
label: "Manager Approval",
field: "LightApproved",
data: apply(
rule!ApacMobileConvertStatusManagerToLight,
index(
local!datasubsetOpenRequest.data,
"LightApproved",
{}
)
),
size: "ICON"