Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


CR 10 pipe delimited txt output

CR 10 pipe delimited txt output

CR 10 pipe delimited txt output

Im running CR 10 on CE10 and trying to produce a pipe delimited txt file. I do not want to have any quotes or additional spaces in the output.

a sample row would be


for example

1000515|12/01/2007|OVER LIMIT|
Is there a combination of txt output options that work?
So far I can produce a report that looks fine in CR until I try to export it as a .txt.

RE: CR 10 pipe delimited txt output

You could include in the detail section a single string formula that returns all of the desired text.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

RE: CR 10 pipe delimited txt output

Exporting Crystal Reports to various text formats can always be tricky.  I created a sample report that exported to a pipe-delimited format in CR10.  Here's what I did to make it export properly:

1) Eliminate all unnecessary headers and footers, including the page headers with the labels.  You're going to be exporting to .csv (character-separated values) format, which is intended for data only, not headers....  Typically, you'd import such a file into some other system.  The only section you should export is the detail section.

2)  Use guidelines to lock the detail section field down. Eliminate all empty space between all fields.  Don't worry about making the field 'fit' the data.  It's easier if you set the field width to a static value for all fields.

3)  Export the report to Separated Values (.csv) format. Select | as the character by which to separate the values and clear the box completely for the delimiter.  Do not check the boxes to keep numbers and dates in the same format.

Voila!  Your report is now exported to a clean, pipe-delimited file.

If you are concerned about date and number formatting, I would recommend you convert these fields to text datatype with the appropriate formatting prior within the report itself.



RE: CR 10 pipe delimited txt output

Thanks to both of you. Actually the report required the data be grouped by ID and sumarized. Following your suggestions I used a combination of both a single text box to hold each row and formulas and formatting to get the final formatting to work.
Crystal had an obsession about adding comma separators and decimal points to the first number in the group and formatting the date as M/D/YYYY, so I used totext with options for no commas or decimals or decimal points. ToText ({prog_ID},0,"",""). The date field could be formated as MM/DD/YYYY. The default options are not always what we want and it would take a supernatural act to have them altered in our shared environment.

Finally the export was set up as plain txt. In the report writer Paginated text with a 0 selcetion worked, but this option was not available in Crystal Enterprise.
Thanks Again!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close