Combining Expressions
Hi,
In Viaual Studio how can I combine two expressions?
I want to combine '=Fields!FinYear.Value' and '=Fields!Period.Value'(separated with a /) so that period one of 2012 would appear as 2012/01, period 2 of 2012 would appear as 2012/02 etc.
Is there a way I can do this?
Cheers
Paul
July 23rd, 2012 8:00am
Hi Paul
Try Below Expresion. Let me know you are looking for any other approch.
=Fields!FinYear.Value+"/"+Fields!Period.Value
Suhas KudekarMark as Answer if this resolves your problem or "Vote as Helpful" if you find it helpful.
My Blog
Follow @SuhasKudekar
Free Windows Admin Tool Kit Click here and download it now
July 23rd, 2012 8:42am
That didn't work. My output is appearing as attached.
Having said that, I couldn't even get the table to generate so its getting closer to what I'm looking for.
July 23rd, 2012 9:27am
=CStr(Fields!FinYear.Value)+"/"+CStr(Fields!Period.Value)
Try thisShahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
July 23rd, 2012 9:42am
=CStr(Fields!FinYear.Value)+"/"+CStr(Fields!Period.Value)
Try thisShahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com
July 23rd, 2012 9:42am
=CStr(Fields!FinYear.Value)+"/"+CStr(Fields!Period.Value)
Try thisShahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
July 23rd, 2012 9:48am
=cstr(Fields!FinYear.Value)+"/ "+cstr(Fields!Period.Value)
July 23rd, 2012 9:57am
Use & rather than + to concatenate:
=Fields!FinYear.Value & "/" & Fields!Period.ValueThink out of the box
Free Windows Admin Tool Kit Click here and download it now
July 23rd, 2012 12:12pm
Cheers guys. That was very helpful!
July 24th, 2012 3:51am