Fixed File Format 1

[HRISUser]

I am trying to create my first fixed file format report using Crystal. The report is rather large and has about 100 columns of data. I don't want to print the file on a page, I just want to generate a file to send to a vendor. The previous reporting software that I used, I could have fields on the side of the page hanging off the margins, but I am unable to use the same work around in Crystal. Is there a setting that I can select so that crystal will allow me to have as many columns of data without limiting me to the physical size of a page? Does anyone have a better solution or a way that might work--unfortunately Crystal is the only reporting software that my company has.

 

[synapsevampire]

Install the HP Designjst 3500 CPS printer (standard Windows printer), which allows for over 100" in landscape.

And since you're using a fixed field report size, you'll probably need to pad everything anyway within a formula, so just shrink up the formulas.

Example of padding is:

trim({table.field}) + ReplicateString(" ",20-len(trim({table.field}))

Adjust the 20 to the length you need, and of course you'll need to convert all dates and numerics to strings to accomplish this using the totext() function.

-k