{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 贪生不怕死 的问题《SQL reporting services report not showing date in》','https://www.manongdao.com/q-1045802.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
i have built a reporting services report off SQL server 2005 and am having trouble getting the date to format correctly in a stand-alone textbox.
The code i am using is as follows:
="Date: " & FormatDateTime(Parameters!date.Value, 2))
-- According to MSDN it should work off my systems culture when set to '2' however it is not.
Currently being displayed = MMDDYYYY, Want to display = DDMMYYYY
Does anyone know what i am doing wrong?
The reports have their own Internationalisation settings - they don't use the systems.
Open your report Properties page (Click on the blank area of the report and check the Properties panel) and look at the Language settings. It will be set to English (United States). Set it to =User!Language to make it respect the user's regional settings.