CODEWITHSUNDEEP
reporting-servicesssrs-2008ssas
HelloWorld1
HelloWorld1

Reputation: 14108

Remove the Whitespace

Direction:
Display the list without white space in the beginning of every row in SSRS by using expressen code.

Requested result:

a
------------------
aaa
aaa ss
bb - bb-
ss - -dd
ddd ddd
dd dd dd - dd

Obstacle:
How should I enable to remove the white space in order to achieve the requested result.

Information:
The data is taken from a table (dimension table) in SSAS. THe data will be used inside of a textbox.

Current situation:

a
------------------
   aaa
 aaa ss
   bb - bb-
  ss - -dd
          ddd ddd
   dd dd dd - dd

Upvotes: 0

Views: 2344

Answers (1)

Jacob Goulden
Jacob Goulden

Reputation: 371

=LTrim("string")

That should be all you need. Where to apply it I'm not sure without more info

EDIT:

If the data is being put into a textbox, just use it as an expression for the box.

Upvotes: 2

Related Questions