Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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!

Join Tek-Tips
*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.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

JC442 (MIS) (OP)
10 Nov 06 18:29
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

prog_id|Date(MM/DD/YYYY)|Comment

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.








Helpful Member!  IdoMillet (Instructor)
10 Nov 06 22:54
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.
www.MilletSoftware.com

Helpful Member!  rhinok (TechnicalUser)
12 Nov 06 17:38
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.

~Kurt

http://www.acuityreporting.com

JC442 (MIS) (OP)
13 Nov 06 18:10
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!
Jim
 

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