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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics