Link to home
Start Free TrialLog in
Avatar of shulamitg
shulamitg

asked on

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.
Avatar of cyberdevil67
cyberdevil67

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.
Avatar of shulamitg

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of cyberdevil67
cyberdevil67

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial