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.
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.
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.