Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

How to export a long fixed length string in Crystal Reports

September 16, 2009 by Wayne Schulz

long string crystal export.jpg

Have you ever tried to create a fixed length export file with Crystal Reports? These are typically files you create to send to some third party like a bank. They’ll give you a fixed length record layout and tell you where each field should go and how long it must be.

Everything works well so long as you don’t have a super long length of text.

Well today I had a client that wanted to export a fixed length line of text that was 200 characters long. Crystal Reports wouldn’t export to text without wrapping the line which would have been a problem for the bank to read.

Exporting to a text file via Crystal Reports appears to have a hard limit of a certain size width that’s keyed into how wide the paper is as defined by your printer..

Smaller fonts can combat this to some extent but in my experience not completely.

Some suggestions were to shrink fonts (works to the extent that the fonts can be made small enough) and try different printer drivers that may support larger paper widths (not all drivers support larger paper and it can be a pain to install and maintain a standard printer driver on every machine).

Here’s what ultimately worked for me to export a very wide Crystal Report to text:

Within Crystal Reports 10 – Instead of selecting txt as the export source I selected “record style columns no space” and checked off both “same number style as in report” and “same date formats as in report”

Have not fully tested against the bank yet but appears ok in the WordPad preview.

Share this:

Filed Under: Sage 100 ERP, Tips and Tricks Tagged With: Crystal Reports, mas200, Sage 100 ERP

Secure cloud hosting for Sage 100
Call 1-888-244-6559 (toll-free)

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 since 1986 and provides advanced support to companies located throughout the United States. If you are experiencing an issue with Sage 100 and would like to schedule a support session - please request assistance here or call 860-657-8544.

Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 News

  • Will There Be A Sage Summit for Sage 100 Users in 2022
  • Avalara Outlines Setup for July 1, 2022 Colorado Retail Delivery Fee
  • Sage 100 API Offered by ROI Consulting
  • Sage 100 Paperless Electronic Delivery Via Gmail Requires App Password or OAuth Starting May 30, 2022
  • Best Practices for Sage 100 Security
  • SPS Commerce MAPADOC EDI for Sage 100 2022 Due for June 22, 2022 Release
  • Can Sage 100 Premium ( SQL ) Be Migrated Back To Non-SQL ( Providex?)
  • Sage 100 2022 Requires New Activation Key for Production Management Installation
  • Sage Releases Sage 100 v2022
  • What File Prerequisites are Required by Sage 100 v2021?

Contact Us

Schulz Consulting
Connecticut Office
Phone: 860.657.8544
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2022 · Parallax Pro Theme on Genesis Framework · WordPress · Log in