How to translate "chart title" in a report?

[Isabela Loebel]

Hey everyone,

I did a report that shows the expired licenses, it shows the total of licenses, as the image below.

What I'm trying to do is, in this report I need the 'chart title' to be translated to Spanish and Brazilian Portuguese. I tried to change the Language in Settings and updated the word, but as I said, it didn't work. Another way i've already tried was "System Localization -> Message", but it doesn't apply on this field.

I need it to look like this when the Language Setting changes: 

Does anyone know how to do it?

Thank you in advance,

Isabela

[Musab Rasheed]

Hello,

Looks like you have to make entry in sys_ui_message table, go through below article which will help you to understand how exactly translation works.

https://community.servicenow.com/community?id=community_blog&sys_id=b7aa7844db94b4144819fb24399619fb

Regards

[Isabela Loebel]

Thanks for replying @Musab Rasheed, 

But I've read and tried this too. I've already included it in message table and tested the link you said, none of them worked. Don't you know any other way? 

[Alex Coope - SN · Accepted solution]

@Isabela Loebel,

I'm afraid an entry in [sys_ui_message] won't be the solution here. The entry in question is driven by the [sys_report.chart_title] & [sys_report.title] fields, which ootb is a "string" field type. These field types aren't translatable, so in order to make it work you would need to change the type on those fields to a "translated_text" field type (another type of string field that is translatable).
* Make sure you don't adjust the length of the field to avoid any potential data-loss and thoroughly test on a sub-PROD instance.

We actually have a KB article on NowSupport (the artist formally known as "hi") available here, and to understand how to populate the [sys_translated_text] table for the actual translations have a quick check on my blog post on how the 5 translation tables work available here, 

Many thanks,
Kind regards