Display data according to cultural settings in SQL Report
-
Dear friends, In my asp.net 2.0 website, I added a Report. I am using cultural settings in my site. Is there any way to display the data in the report based on cultural settings. ie, if the cultureInfo="en-US", the date data in report should display in MM/dd/yyyy format. if the cultureInfo="en-GB", the date data in report should display in dd/MM/yyyy format. Please give me a suggestion for this problem
Shivanandan C V
-
Dear friends, In my asp.net 2.0 website, I added a Report. I am using cultural settings in my site. Is there any way to display the data in the report based on cultural settings. ie, if the cultureInfo="en-US", the date data in report should display in MM/dd/yyyy format. if the cultureInfo="en-GB", the date data in report should display in dd/MM/yyyy format. Please give me a suggestion for this problem
Shivanandan C V
Shivan Nandan wrote:
I added a Report.
What report is it? A crystal report or some other?
DateTime.Now.ToString()has got overloads, where you can specify the pattern you want to display the date. :)Navaneeth How to use google | Ask smart questions
-
Shivan Nandan wrote:
I added a Report.
What report is it? A crystal report or some other?
DateTime.Now.ToString()has got overloads, where you can specify the pattern you want to display the date. :)Navaneeth How to use google | Ask smart questions
I have used SQL Server Reporting Service. In that I kept a table and on that, added fields from dataset which includes a datetime field also. This report is bound to a ReportViewer Control in the aspx page. In this aspx page, I have set the culture. While displaying Date on this page, it displays based on the culture I have set, but the report displays date in local system settings.
Shivanandan C V