We have users in both UK/USA. When they create webi reports through infoview and if their report contains a date field, is it possible for the format to be different based on location? For e.g dd/mm/yyyy in UK and mm/dd/yyyy in USA.
Currently i know that if users set this in their preferences "Under Preferences -> General -> Preferred Viewing Local" this can work. But in our implementation we ideally want to restrict users from setting their preferences as we want to maintain an uniform look and feel to infoview.
So far based on search there seems to be no work-around. Any ideas, ideas most welcome.