It shouldnt matter the report content or level its a user experience question.
Say I have a simple table in a report with 3 columns Name, Date and Value
A user in the US might want to see the table like (Date formatted MM/DD/YYYY, Value #,##0.00)
NAME DATE VALUE A 04/20/2017 1,000.00 B 04/15/2017 2,000.00 C 04/17/2017 3,000.00 D 04/01/2017 1,750.00 E 04/07/2017 1,000.00
A user in the UK might want to see it like (Date formatted DD/MM/YYYY, Value #,##0.00)
NAME DATE VALUE A 20/04/2017 1,000.00 B 15/04/2017 2,000.00 C 17/04/2017 3,000.00 D 01/04/2017 1,750.00 E 07/04/2017 1,000.00
A user in Germany might want to see it like (Date formatted DD/MM/YYYY, Value #.##0,00)
NAME DATE VALUE A 20/04/2017 1.000,00 B 15/04/2017 2.000,00 C 17/04/2017 3.000,00 D 01/04/2017 1.750,00 E 07/04/2017 1.000,00
I have with my users a language attribute in the data so en-gb for UK users, en-us for US users de for German etc...
I'm looking for the most appropriate way to bring this into my reports.
Do I go the section access route?
Do I create a language group?
Or can I leverage the locale field in the user import file?
Or do I use a user filter on a report to pass the variable or create sesperate reports per language and group the users or apply a report filter?
Looking for the pros and cons of each approach?