Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Blessed1978
Yak Posting Veteran
97 Posts |
 Posted - 2014-07-29 : 10:55:28
|
| I created the below expression in SSRS 2012 that i am using for my report's column header. The problem i have is to format the DATE into MMM-YYYY formula example from 1/1/2013 to JAN 2013. My formula is puttin the value as 1/1/2013. I dont want it that way it should be inJAN 2013 format . I know i can go to text box properties and set the date format i did that and it doesn't work. However if seperate my parameters in different test boxes it works. However i want to concatenate both parameters into one. PLEASE ASSIST="CREDIT Report:" & Parameters!code.Value & " " & Parameters!date.ValueresultCREDIT REPORT:COR1030 12/1/2013IT SHOULD BE CREDIT REPORT:COR1030 jan 2013 |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-07-29 : 11:52:18
|
| lookup the FormatDate function, Here's one reference: http://www.jackdonnell.com/?p=122 |
 |
|
|
Blessed1978
Yak Posting Veteran
97 Posts |
Posted - 2014-07-29 : 12:50:04
|
| Nvrmind mind I figured it out I simply added format to my second parameter MMM, yyyy. It worked |
|
|
|
|
|
|
SSRS CONCATENATE MULTIPLE PARAMETERS ISSUE