2 Replies Latest reply on Mar 29, 2014 7:32 AM by hanstrager

    Help to construct a print script

    hanstrager

      Title

      Help to construct a print script

      Post

           Have some records with a description field.

           I want to make a print layout, but only print the records where the description field isn't empty.

           So far I've just got the standard (see underneath), just not sure how to approach "only print if there's some text in the field called 'Comment'"

            

      Go to Related Record [ From table: “OTHER ITEMS”; Using layout: “Other Items List PRINT” (OTHER ITEMS) ] Print Setup [ Orientation: Landscape; Paper size: 8.26" x 11.69" ]

      [ Restore; No dialog ]

      Print [ Records being browsed; All Pages; Orientation: Portrait; Paper size: 8.26" x 11.69" ] [ Restore: Agency Colour ]

      Go to Layout [ “Other Items List” (OTHER ITEMS) ]

            

        • 1. Re: Help to construct a print script
          philmodjunk

               The print setup and go to layout steps don't seem needed.

          Go to Related Record[ From table: “OTHER ITEMS”; Using layout: “Other Items List PRINT” (OTHER ITEMS) ]
          Print Setup[ Orientation: Landscape; Paper size: 8.26" x 11.69" ][ Restore; No dialog ]

          Print[ Records being browsed; All Pages; Orientation: Portrait; Paper size: 8.26" x 11.69" ] [ Restore: Agency Colour ]

          Go to Layout[ “Other Items List” (OTHER ITEMS) ]

          Looks like you need to add this code after the Go to related records step:

          Enter Find Mode []
                         Set Field [Other Items::Comment ; "*"]
                         Constrain Found Set[]

                          

                

          • 2. Re: Help to construct a print script
            hanstrager

                 thank you works perfect