AnsweredAssumed Answered

Pentaho Report designer - parameterization on Locale Date format (~environment designtime- Locale)

Question asked by Kiruthika M on Feb 4, 2019
Latest reply on Feb 6, 2019 by Kiruthika M

Irrespective of locale date format, I need to genereate the report with the date format of the locale which i passed in runtime. Am getting the expected results when I am editing fr in environment-designtime-locale and running it. But I want that to Dynamic.

Is anything doable in Penatho Report Desinger end to achieve it.

Finally I want the output in PDF fomrat with the dateformat am providing.

What I have already tried:

SQL level query modification is not accepted. Since for every date field we have to identify and do the query levle modification.

select FORMAT ( sample_date_field, 'f', ${Param_Locale} ) --> Param_Locale--> fr.

Outcomes