Question

Translation support for Quick Reports

  • 24 September 2021
  • 2 replies
  • 48 views

Userlevel 1
Badge +1

Dear IFS Community,

We have a request to translate Quick reports into German Language in Apps9. As far as I’m aware, Quick Reports are not translatable.

Do you know any workaround other than duplicating existing quick reports and write in German (Titles, columns names, parameters and comments)?

Thank you!

Best regards,

Jeevanie Nisansala


2 replies

Userlevel 7
Badge +15

One workaround would be to write out the translated column headers as the first row of data, then do a UNION ALL with the real report data. The trouble with this is that DATE and NUMBER columns won’t be regionally formatted with the settings from the user’s workstation because they’d have to be converted to VARCHAR2 in the query for the UNION to work. 👎

Userlevel 1
Badge +1

One workaround would be to write out the translated column headers as the first row of data, then do a UNION ALL with the real report data. The trouble with this is that DATE and NUMBER columns won’t be regionally formatted with the settings from the user’s workstation because they’d have to be converted to VARCHAR2 in the query for the UNION to work. 👎

Thank you Kevin for your suggestion. As you have also explained this will not workout for NUMBER and DATE columns with regional formatting. However, I really appreciate your input.

 

Just wondering how other IFS customers use language translations in quick reports.

Reply