Text mode grouping for hours

[RathinaGopalan]

Hello,

I want to group the hour type report in text mode and show grouping as "Billable" if hour type id is task time or issue time and as "Non Billable" for rest of hour types. Please help me here to achieve this grouping.

[Richard_Le_ · Accepted solution]

Hi,

The following text mode should do it:

textmode=true
group.0.displayname=Hour Type
group.0.valueexpression=IF({hourType}="Task Time"||{hourType}="Issue Time","Billable","Non Billable")
group.0.valueformat=string

Best Regards,

Rich.