ACC: How to Print a Conditional Page Header in a Report 1.x/2.0

MORE INFORMATION

Reports print group header information once per group, even if the group of data spans more than one page. In reports, a common layout is to place the grouping value in the group header along with the column labels. However, because this data is not repeated when a group spans more than one page, the column header labels are not repeated on the subsequent page(s).

To create conditional headers, you must create a new page before each group of data and set a flag from the group header to determine when the page header should print. Then, from the group footer, set the flag back so that the page header does not print at the beginning of the next group.

To create the conditional headers, follow these steps:

1. Open the sample database NWIND.MDB.
2. Create a new form called FlagForm. This form is used to store a global variable.
3. Create one unbound control and set the following property:
   
   Name: Flag
   
   NOTE: In Microsoft Access version 1.x, the Name property is called the ControlName property.
4. Create the following new macro, and name it Test:
   

         Macro Name        Condition                       Action
         -------------------------------------------------------------
         SetFlag                                           SetValue
         ShrinkPageH        Forms![FlagForm]![Flag]=1      CancelEvent
         FlagOn                                            SetValue
         FlagOff                                           SetValue
   
         Test actions
         ---------------------------------
         SetFlag
            Item:  Forms![FlagForm]![Flag]
            Expression: 1
         CancelEvent: no arguments
         FlagOn
            Item:  Forms![FlagForm]![Flag]
            Expression: 0
         FlagOff
            Item:  Forms![FlagForm]![Flag]
            Expression: 1
   						

5. Create a new blank report called PrintHeaders based on the Products table:
   
   
   1. Set the following report header properties:
      

               OnFormat: Test.SetFlag
               Height: 0
      								

   2. Set the following page header property:
      

               OnFormat: Test.ShrinkPageH
      								

   3. Create a label in the page header section and set the following property:
      

               Caption: Continued from Previous Page...
      								

   4. Create a grouping for the Category ID and set following properties:
      

               Group Header: Yes
               Group Footer: Yes
      								

   5. Set the following group header properties:
      

               OnFormat: Test.FlagOn
               ForceNewPage: Before Section
      								

   6. Create a control in the group header section bound to the Category ID field.
   7. Create a text box control bound to the Product Name field in the detail section.
   8. Set the height property for the detail section to 2 inches. (This is to create groups of data that span more than one page.)
   9. Set the following group footer property:
      

               OnFormat: Test.FlagOff
      								

6. View the FlagForm form in Datasheet view.
7. Preview the PrintHeaders report.
8. Scroll through the report. Note the page headers for the groups.