tag:blogger.com,1999:blog-495177919198719500.post7912803780315014827..comments2023-12-27T20:52:29.483-08:00Comments on Microsoft Sql Server Tutorials: Format dates in SSRS reportsSuprotim Agarwalhttp://www.blogger.com/profile/08349831623922214390noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-495177919198719500.post-57426675618386718222012-07-24T21:35:44.365-07:002012-07-24T21:35:44.365-07:00Thank for your post.lot of helpfulness for meThank for your post.lot of helpfulness for meEzhumalai Mhttps://www.blogger.com/profile/15960300137100430899noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-2462429876054877202011-01-20T12:04:13.946-08:002011-01-20T12:04:13.946-08:00Hi,
I am having a problem with SSRS
I have a col...Hi, <br /><br />I am having a problem with SSRS<br />I have a column with data type in Time format like<br />12:24<br />06:45<br /><br />I need to sum up the values and display as a total.<br /><br />Can any one provide me the expression please.POLLADHAVANhttps://www.blogger.com/profile/06280824736799665029noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-75645829938207291542010-12-09T05:56:16.827-08:002010-12-09T05:56:16.827-08:00Hi, I'm doing something like this
"=Form...Hi, I'm doing something like this<br /><br />"=Format(Fields!dataRef.Value,"MMMM")+ "/"+Format(Fields!dataRef.Value, "yyyy")"<br /><br />Can I translate the month's name to portuguese?<br /><br />Thank you.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-67177385404388524232009-07-26T22:23:09.320-07:002009-07-26T22:23:09.320-07:00P - You will have to get the previous date in your...P - You will have to get the previous date in your SQL query and then use the same expression to convert it to MMM-yy. Since you haven't mentioned any other conditions on which month of the previous year, here's a post that may help you out<br /><br /><a href="http://www.sqlservercurry.com/2009/05/finding-date-last-year-based-on-current.html" rel="nofollow">Finding the date last year based on the current week </a>Suprotim Agarwalhttps://www.blogger.com/profile/08349831623922214390noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-90399552834911692122009-07-23T12:51:34.986-07:002009-07-23T12:51:34.986-07:00Thank you for this post. one thing I want to do is...Thank you for this post. one thing I want to do is get the previous year using MMM-yy.Philkyhttps://www.blogger.com/profile/04472460962469480250noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-80454368767175409492008-07-09T00:03:00.000-07:002008-07-09T00:03:00.000-07:00Thanks a lot for the different Date formats=Format...Thanks a lot for the different Date formats<BR/>=Format(Today(),"dd-MMM-yy")<BR/>is also one which i was using<BR/>it gives:<BR/>09-Jul-08Smitha Prabithhttps://www.blogger.com/profile/09936100092671177466noreply@blogger.com