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 ]
vBulletin® v3.7.0, Copyright ©2000-2008, Jelsoft Enterprises Ltd.