Combining column (which would come from SQL ) with a static text
I have one "CalculatedYear" in dataset. I want to append it with a static text "Year"
For ex. CalculatedYear=2012 which would fetched from SQL.. and "Year" output must be -> 2012 Year
I want this in data field of table.
could anyone help me with this ?
-Vaibhav Chaudhari
June 29th, 2012 10:08am
Hello Vaibhav,
You can use below expression
=CStr(fields!CalculatedYear.Value) + " 2012"
- Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
June 29th, 2012 10:20am
Hi There
Thanks for your posting, I think you need to do this expression something like this
=CStr(fields!CalculatedYear.Value) + " YEAR"
=CStr(fields!CalculatedYear.Value) + " YEAR"
If you have any question please do ask
Many thanks
Syed Qazafi Anjum
July 14th, 2012 7:25am