Tuesday, 31 May 2016

Number format in SSRS is not number format in excel

Number format in SSRS is not number format in excel

Solution
Use - =CDBL(FieldName.Value) in your expression

How to include space in SSRS expression

How to include space in SSRS expression
Solution - Use =chr(160) & FieldName.Value in your expression

Thursday, 5 May 2016

Default value in switch statement in ssr

Hi Folks,
Follow the below code to get a default  value for Switch statement used in SSRS
=Switch(Fields!PO_TYPE.Value = "Warehouse",1,Fields!PO_TYPE.Value = "Local",1,Fields!PO_TYPE.Value = "Z",3,1=1,4)