crystal2770
Technical User
Can Crystal Reports (8.5) create a positional file type export?
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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
File export
- Thread starter crystal2770
- Start date
- Status
Do you mean a flat file where every field starts at a specific position?
I believer t can be done if the total width of your data is less than 255 characters. Basically, you'll create a formula where you "pad" each field with spaces and concatenate them. Since Crystal doesn't have a "Pad" function, you do it this way:
Left({table.field1} + Replicate(" ", <field1 width>), <field1 width>) + Left({table.field2} + Replicate(" ", <field2 width>), <field2 width>) +...
-Dell
A computer only does what you actually told it to do - not what you thought you told it to do.
I believer t can be done if the total width of your data is less than 255 characters. Basically, you'll create a formula where you "pad" each field with spaces and concatenate them. Since Crystal doesn't have a "Pad" function, you do it this way:
Left({table.field1} + Replicate(" ", <field1 width>), <field1 width>) + Left({table.field2} + Replicate(" ", <field2 width>), <field2 width>) +...
-Dell
A computer only does what you actually told it to do - not what you thought you told it to do.
- Status
Similar threads
- Locked
- Question
- Locked
- Question