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.
