3 Replies Latest reply: May 15, 2014 9:58 AM by Steve Caiels RSS

    Report Width longer than 1000 characters

    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,

      Gene

        • Report Width longer than 1000 characters
          Mike Urbonas

          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,

          Gene[/b][/quote]Gene, have you tried the Monarch "Prep" utility?

          • Report Width longer than 1000 characters
            Gene _

            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

            • Report Width longer than 1000 characters
              Steve Caiels

              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

               

              [size="1"][ October 18, 2002, 08:28 AM: Message edited by: Steve Caiels ][/size]