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.

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 SSRS CONCATENATE MULTIPLE PARAMETERS ISSUE

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.Value
result
CREDIT REPORT:COR1030 12/1/2013
IT 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
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -