We have a range of reports hosted on a website and some of them use the US date formatting (mm/dd/yy) while others us the UK format (dd/mm/yy).
There's two reports that use the same date column in the database but one uses this US format while another uses the UK one. However when I run the reports in the report builder on my local machine both the reports use the UK format (which is what we want it to be).
The server that hosts the reports has its location set to UK and the format for the dates text box is the same in both reports too so I'm not sure what's causing some of these reports to format differently.
I'd have thought if it was an issue with the server then all reports would have the same date format instead of the mismatch that we currently have.
Is it possible there's other settings hidden away somewhere?