Print Page | Close Window

Insert Carriage Return using Formula

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=17373
Printed Date: 25 Apr 2024 at 1:55pm


Topic: Insert Carriage Return using Formula
Posted By: Dawn08
Subject: Insert Carriage Return using Formula
Date Posted: 20 Aug 2012 at 5:12am
I created a formula fields to insert a carriage return.
 
Formula
chr(13)
 
The final result is to try an create an output file using a pipe delimiter and a carriage return at the end of each row of data. When I insert the formula chr(13) field at the end of the row, it is removing the first pipe on the first row - thereby throwing off the data.
 
Any suggestions would be greatly apprecaited.
 
 
 
 
 


Replies:
Posted By: hilfy
Date Posted: 20 Aug 2012 at 6:23am

If your report has each record in a row, you don't need the carriage return - Crystal will automatically do that for you.

 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: Dawn08
Date Posted: 20 Aug 2012 at 7:12am

I think is was a "User inflicted" format issue :)

This was an older report, where I had the data moved up to the header area. Once I moved to the details section - everything worked correctly.
 
Thanks,
Dawn


Print Page | Close Window