Monday, July 27, 2009

SQL 2005 Reporting Service Date Format

When use virtual studio to develop reporting project, the date format is "Default" in property. This default will follow MM/DD/YYYY format. However, in some regions, such as Australia, the date format is DD/MM/YYYY. We can change the date format from "Default" other regions setting. But if this report will be accessed from different regions, such as USA, Australia and China, all use different date format. So the best practice is change "default" to expression "=User!lauguage", it will display the date format based on user's setting.

No comments:

Post a Comment