date format according to regional setting

hi all,

is it possible to format a datetime value in report to display according to the shortdate format set in pc's regional setting ?

i manage to get the parameters to display according to the format in regional setting but is it possible for fields in report to follow shortdate format ?

btw, i can't seem to find the setting for report language under report tab in vs.

i could find language under Tools -> Options -> International Settings -> Language. is it the same thing? cos i've been reading other related posts and seems like the setting can be found under report tab..

Thanks!

Yes, you can specify the format and language style property in the report in order to do that. For detailed information about setting the language property, you can take a look at this page http://msdn2.microsoft.com/en-us/library/ms156493(SQL.90).aspx

|||

hi Fang,

thanks a lot for the swift answer. thanks a lot for pointing me to the url. had been searching high and low through the help file.

i have another problem i.e. i use stored procedure for some of the datasets and the dateformat will cause an error. i know there's a set language function for stored proc but how can i retrieve the pc's regional setting and specify it in the stored proc ?

thanks again!

|||You can pass in User!Language as a query parameter to the stored proc.|||

hi Fang,

i've tried but got this error in RS:

SET LANGUAGE failed because 'en-GB' is not an official language name or a language alias on this SQL Server.

is it the configuration in regional setting?

thanks!