[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 898
  • Last Modified:

dynamiclly new line in a crystal report field object

my field object in crystal report has the data from my stored proecedure in sql.
I want in my store procedure to be able to say  for example: Name = LastName + Newline  + FirstName
and the crystal report should understand the new line I tried  LastName + chr(10) + FirstName but it doesn't work it works only on formula object  and I want it on a field object that comes from data in sql.
  • 2
1 Solution
New lines in windows are usually chr(13)+chr(10), but I am not sure that you can do this in the way you want to do it. However what you could do is have a text object with the fields inside the texbox with the newline in the report itself.
shulamitgAuthor Commented:
I cant do it in the report itself because for what I need is complicatated and I need to do it in the sql if I put chr(10) in sql - the text object shows chr(10) on the report and doesn't look it as a new line.
I don't understand why you need sql to do this and not the report? I am trying to know what you are trying to achieve here.

Anway the only way that I could think this can be remotely achieved, would be to create a custom formula that would actualy split the string into an array and then display the data the way you then need to.

array = split(Fullname,char(10)) should return an array split by the newline then you can do what you need in the report itself.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now