Click here to Skip to main content
15,918,808 members

Comments by Member 12495949 (Top 3 by date)

Member 12495949 26-Feb-18 5:12am View    
CLng also not working for me..converting it into Custom format
Member 12495949 26-Feb-18 5:06am View    
tried all these options, not working for me

1) multiply your cells expression by 1.000 (1 doesn't work!) - this forces SSRS to format the cell as a number. eg; (your expression here) * 1.000

2) =CLng(Fields!FieldValue.Value)

3) For every textbox in the column that contains numeric values, select it and set the Format property to N (number)

4)Make sure your <markuptype>None not <markuptype>HTMLfor the textbox in your tablix or Table.

5)Change the Expression of the textbox to =CInt(Format(Fields.FieldValue.Value, "#,###.0"))
Member 12495949 26-Feb-18 4:50am View    
=CInt(Fields!FieldValue.Value)*1.000, tried this and =(Fields!FieldValue.Value)*1.000, both exported in custom format only