1 Reply Latest reply on Jun 5, 2012 10:29 AM by philmodjunk

    collapse individuals in company when printing a report?

    LucyKenyon

      Title

      collapse individuals in company when printing a report?

      Post

      Can I print a report that collapses all the individuals at each company, so I only get one line per company ? I'm searching for all companies who do, say, engineering, and the results bring up every individual.

       

      eg Big Company

          Medium COmpany

           Red Company

       

      Instead of 

            Big Company Joe

            Big Company                Igor

            Big Company                Matilda   etc..

      Thanks for your help. 

        • 1. Re: collapse individuals in company when printing a report?
          philmodjunk

          Create a list view layout based on this table.

          change the body layout part into a sub summary part by entering layout mode and double clicking the part label to bring up the part setup... dialog

          Select sub summary layout and specify either the company name or a company id field as the "when sorted by" field.

          Return to browse mode and sort your records by the same field you selected as the "when sorted by" field for you sub summary part.