Purpose of multiple formats

You can assign a total of eight formats to a report. Use multiple formats when you want to include different types of information in a single column. Using multiple formats provides an alternative to showing the information in several columns across the page. You must assign the additional formats to the row line. This lets you calculate one row line differently than other row lines. For example, you can create a report that compares current and last year amounts by row.

Example

These two illustrations show report samples that contain the same data. The first report uses a single format and displays the information in multiple columns. The second report uses multiple formats to show two different types of data (total sales and percent of sales) in the same column.


              
              
                          LGE Corporation
                           SALES REPORT
                         January 31, 2000
                          (in thousands)


          HOSPITALS                   Total Sales   Percent of Sales

  Sales-Prescription Drugs           $9,654          15.5%
    
  Sales-Non-Prescription Drugs       $8,337          13.4%
    
  Sales-Clinic Services              $4,000           6.4%
   
  Sales-Hospital Services           $37,301          59.9%
  
  Sales-Other                        $2,000           3.2%


            

              
              
                          LGE Corporation
                           SALES REPORT
                         January 31, 2000
                          (in thousands)


          HOSPITALS

  Sales-Prescription Drugs                   $9,654
       Percent of Sales                       15.5 %

  Sales-Non-Prescription Drugs               $8,337
       Percent of Sales                       13.4 %

  Sales-Clinic Services                      $4,000
       Percent of Sales                        6.4 %

  Sales-Hospital Services                   $37,301
       Percent of Sales                       59.9 %

  Sales-Other                                $2,000
       Percent of Sales                        3.2 %