Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting ??

Status
Not open for further replies.

lisa626

Programmer
Aug 9, 2006
92
US
Currently using Crystal XI, I have a data file that I need to export with some specific settings, not sure if Crystal can do this.

I need to export in a pipe delimited format, also need to specify field lengths, specific formatting.

Example

Field 3 represents a rate ($),

$13.00 needs to show as 000000000001300
$123.54 would be 000000000012354

Any help with this would be greatly appreciated.
 
One option is to create a formula that returns all the necessary text (including the delimiters). Place that formula in the detail section and export to TEXT.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top