Microsoft Dynamics 365 | Integration, Dataverse...

How to remove space with in the string using SSRS expressions

(0) Share

Report

Posted on by Sandy Hello

342

I have ssrs report the numeric value in the report is displayed as text with space in between i.e. 19999 is displayed as 19 999 , i want to remove the space and convert it into integer.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Chris Haley on at

Like (1)

Report

You should be able to untick the 'Use 1000's separator' option in the number format box in the report designer.

Try reading the following link:

www.tutorialgateway.org/.../

Was this reply helpful? Yes No
Sandy Hello 342 on at

Like (0)

Report

Hi Chris Thanks! for response

this is not helpful for me any simple method or direct function to remove space in the string

Was this reply helpful? Yes No
Sandy Hello 342 on at

Like (0)

Report

=Val(replace(Fields!duration.Value," ","")) this is giving values as integers but from 19 999 it is giving only first two digits 19

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Sandy,

My recommendation instead of using Fields!duration.Value (that is basically formatted value of your int) you should use Fields!durtion_value!Value that basically contains then integer value of your field.

Good luck and don't forget to close previously opened thread - community.dynamics.com/.../filed-defined-in-crm-dynamics-as-whole-number-is-displayed-as-text-in-ssrs-report-to-excel

Was this reply helpful? Yes No
Sandy Hello 342 on at

Like (0)

Report

Thanks Andrew. Issue fixed with field pointing to Fields!durtion_value!Value

Was this reply helpful? Yes No
a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Sandy,

If my reply resolved your issue take a minute and click "Yes" under "Did this answer your question?" message.

Was this reply helpful? Yes No