A user create a list data. On the list data, there are list-options with statuses (see img1.png).
On another page, there is a report to capture the status data. However, on the page, the report will show regular text without the style/color of the status (see img2.png)
Immanuel Siagian
In reply to Azwandi's suggestion, that only works well for small numbers of status items.
In cases where there are more options, multiple columns, or other factors, it can become unsustainable. In our case, using that technique would require about 250 macros now, and that could grow to almost 500 macros with a few additional (planned) options.
If the Report Info macro would show the status options correctly that would be reduced by a factor of 10. Given how useful Status macros are, and how (visually) they make a big difference in how easy the table is to quickly process, this is something that I think should be built in, not something that require a complex workaround.
More generally, I think reports should always be able to display not only the text representation, but the *content* of what it's reporting on. That's really the limitation here - in the report, whatever is contained in the List Option is ignored, and the plaintext is the only thing the report can use.
Attachments Open full size
This can be worked around with https://docs.servicerocket.com/reporting/user-guides/recipes/miscellaneous/creating-an-if-else-statement-with-reporting
Attachments Open full size