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!

*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




Trying to import data from an Excel file that has many Order headers and Order lines. I need to convert it into a fixed length text file so I can import the information into our accounting system. Unfortunately the import is fixed width and dependent on the column position. I have it working with one problem I have the order header information in group header#1 were the first two columns start with "SO". I have the lines in the details section and each line starts with "SL". When I do the export to text everything is there except the lines always start in Column 2 instead of column 1.
Therefore the entire order line is off one position. I can manually delete the space in the text file and do the import but trying to resolve the issue. Any suggestions? Both the "SO" and "SL" fields are inserted text objects and not imported from the data file

RE: Alignment

How does Crystal Reports fit into this? Are you using the Excel file as a data source and then trying to format it in Crystal for the import by your accounting system?

Be sure to attach all fields AND the text boxes to guidelines. Then also right click in design mode and select all fields and objects by section and right click->format fields->make same height->then also choose align bottoms and then also select "fit to section" (another right click).


RE: Alignment

yes, using Excel as a data source - File downloaded from the web then massage it with Crystal reports so it is accepted by our accounting system. Using Crystal Reports 9. When you preview it in Crystal it looks correct but export it to a text document it adds a blank space at the beginning of the detail line

RE: Alignment

Did you use the guidelines? If header and detail fields are attached to the same guidelines, sized with the same height, with bottoms aligned, they should be aligned when exported. Make sure that the export uses the group header or detail section to define column width in the export options.


RE: Alignment

Did as suggested, exports perfectly to PDF, but to text it still adds a blank line

RE: Alignment

Are the "SO" or "SL" the only contents of the text boxes? If so, try replacing them with a formula, e.g.,


Again, use the method described earlier to align.

If there are other contents in the text boxes, test the alignment by moving the guidelines and make sure the boxes are attached. Also, are you sure there isn't a leading space before the contents?


RE: Alignment

I tried more data and realized that only the very first line starts in column 1. Any lines after that start in column 2
So If I have more than one header line the "SO" will start in column 2

RE: Alignment

Another option is to build one formula (which could be constructed from multiple sub-formulas) that creates the output line with all of the spacing required. Then you're exporting a single field and you don't have to line anything up.

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! Already a Member? Login

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