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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export to Text-Inconsistent Field Size

Status
Not open for further replies.

fsub

Programmer
Feb 2, 2006
60
US
I am exporting a report to text in Crystal 8.5. How can I control the field size? The resulting text differs from preview, i.e., a 5-digit value is written out 4-digit. How can I tell Crystal to write out a field as 5 digits in the output text file?

Thanks...
 
You'll need to pad the output.

Here's a method:

{table.field} & replicatestring(" ", 5-len({table.field}))

Of course this means that you need to convert all data types to strings as well.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top