Hi Ramesh,

Please try using the Agreegate function present for each coulmn at the design time of report definition. Every coulumn is follwed by a fx button which will show you some SQL functions which can be useful. Else please refer PDN to create a new SQL function as per your requirement and apply on the column to get the desired output.

Hope this helps.

Thank you very much for your are response and i am trying with function alias.And What is new SQL function function i think your refering function alias only?