Print Page | Close Window

How to Split a Field to Vertical in Detail Section

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10691
Printed Date: 27 Apr 2024 at 2:20am


Topic: How to Split a Field to Vertical in Detail Section
Posted By: @n70n1
Subject: How to Split a Field to Vertical in Detail Section
Date Posted: 29 Jul 2010 at 8:24pm
Hello ??? anyone can help me please...
I want to Split a Field to Vertical in Detail Section, like this :

Data From Database on InvoiceNo Field :
row 1 : 002,005,006
row 2 : 001,003
row 3 : 004

I want the result like this :
row 1 : 002
            005
            006
row 2 : 001
            003
row 3 : 004

thanks b4




Replies:
Posted By: Emir_W
Date Posted: 30 Jul 2010 at 5:16am
you can use: replace({tbl.field},",",chr(13))
 
 
hope it help.
 


-------------
Emir W


Posted By: @n70n1
Date Posted: 30 Jul 2010 at 3:47pm
Yupzz... thanks very much Mr. Emir_W...
it's run succesfully with click the Can Grow checkbox on common tab (Format Field).. Success for u bro... Wink



Print Page | Close Window