PDA

View Full Version : Report Width longer than 1000 characters


Gene
October 16th, 2002, 02:11 PM
I've got a four line report that line breaks around 1000 characters. However, the fourth line extends out to around 1200 characters. When opening this report, the end of the report is cut off. Does anyone know a way around this?

Thanks,
Gene

Mike Urbonas
October 16th, 2002, 06:27 PM
Originally posted by Gene:
I've got a four line report that line breaks around 1000 characters. However, the fourth line extends out to around 1200 characters. When opening this report, the end of the report is cut off. Does anyone know a way around this?

Thanks,
GeneGene, have you tried the Monarch "Prep" utility?

Gene
October 17th, 2002, 10:44 AM
That seems to work... Can we try to take this one step further...

I've got a project that opens 98 report files and extracts the data we need. Is there a way to automate the prep utility to prepare these files. The contents of these files change Wednesday morning and Friday afternoon....

Any suggestions would be appreciated.

Thanks

Steve Caiels
October 18th, 2002, 09:24 AM
Hi,

You can control Prep by using command line switches and batch files. Your 98 file names would need to have the same name each time

This is an extract from the Monarch 6.00 help file.

Any output that can be produced by operating Prep interactively can also be produced by using a Prep command line. The syntax for a Prep command line is:

prep inputfile outputfile conversion parameters

To break long lines into shorter segments, use the following command

PREP inputfile outputfile LONG length1...length

In the following example, each record is broken into three lines of 200, 190 and 220 characters. (You will need to run an interactive Prep session to determine the best line lengths to specify for a given file.)

prep invoice.dat invoice.prn LONG 200 190 220

regards
Steve

[ October 18, 2002, 08:28 AM: Message edited by: Steve Caiels ]