Eclipse Community Forums: BIRT » Simple way to add space to a data element

Help

Home

Home » Archived » BIRT » Simple way to add space to a data element(How do I pad a string with leading spaces?)

Show: Today's Messages :: Show Polls :: Message Navigator

Simple way to add space to a data element [message #1434291]

Mon, 29 September 2014 23:23

Norm Merrill

Messages: 9
Registered: September 2014

Junior Member

I have a hierarchy report and I want to indent the children. I have a level value field but cannot figure out how to add spaces in front of the children based on the level. I used LPAD in my SQL statement and it works fine but cant get the report to reflect the tree structure. I would think theres a way to do this with the expession builder. Any suggestions?

Thanks

Norm

[Updated on: Tue, 30 September 2014 18:32]

Report message to a moderator

Re: Simple way to add space to a data element [message #1434959 is a reply to message #1434291]

Tue, 30 September 2014 21:34

Norm Merrill

Messages: 9
Registered: September 2014

Junior Member

After trying a few different ideas (BirtStr.concat), I noticed that the leading spaces are coming through from the SQL statement but they are being stripped in the report. So I guess my real question is how do I keep the leading spaces from being stripped?

Report message to a moderator