Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
ogster1974
Partner - Master II
Partner - Master II

Localisation of Reports

Hi Experts

I have reports that im producing for a global audience what is the best practise for making sure:

Dates are formatted correctly

E.g.

US users like to see dates in MM/DD/YYYY format

ROW users like to see dates in DD/MM/YYYY format

Numbers are formatted correctly

E.g

UK users like to see numbers 1,000.00

German users like to see numbers 1.000,00

Any thoughts and recomendations on the best way to bring this kind of presentation into the reports.

Regards

Andy

1 Solution

Accepted Solutions
7 Replies
Anil_Babu_Samineni

Does your data fetching country level or world wide. If country level it may possible by using Ad hoc reports. But, If World data then could be a different approach. I am not sure whether that will work for Dashboard oriented

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
ogster1974
Partner - Master II
Partner - Master II
Author

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)

NAMEDATEVALUE
A04/20/20171,000.00
B04/15/20172,000.00
C04/17/20173,000.00
D04/01/20171,750.00
E04/07/20171,000.00

A user in the UK might want to see it like (Date formatted DD/MM/YYYY, Value #,##0.00)

NAMEDATEVALUE
A20/04/20171,000.00
B15/04/20172,000.00
C17/04/20173,000.00
D01/04/20171,750.00
E07/04/20171,000.00

A user in Germany might want to see it like (Date formatted DD/MM/YYYY, Value #.##0,00)

NAMEDATEVALUE
A20/04/20171.000,00
B15/04/20172.000,00
C17/04/20173.000,00
D01/04/20171.750,00
E07/04/20171.000,00
ogster1974
Partner - Master II
Partner - Master II
Author

Any thoughts on this?

Anil_Babu_Samineni

I got the requirement. I am saying i would suggest to go Ad Hoc reports with Country based for conditional enable. JAM He marcus_sommer‌ may help for us

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Kushal_Chawda

how do you recognize that user is from UK or Germany etc?

ogster1974
Partner - Master II
Partner - Master II
Author

Interesting question.

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?