Services > Tips & Tricks >Creating a 2-Level Header

• services
• education
  • schedule
  • classes
    • accelerated diver
    • advanced data integration
    • control charts in diver
    • dial / di-analyst scripting
    • diveline administration
    • configuring user security
    • diveport administration
    • diver advanced
    • diver basics
    • diver graphics
    • diver intermediate
    • intro to data integration
    • intro to the diver solution
    • model design
    • report palette
    • report writer
  • courses
  • local interest
  • hotels
  • transportation
  • directions
  • cancellation policy
• tech support
• consulting
• on-demand bi
• platforms
• tips

To access our tip & trick library, CLICK HERE.

creating a 2-level header

This technique will be helpful for Power Users. You may have a report with repetitive column names — in this example, the word “Root Beer” repeats in three of the column headings. In your final printed report, you can display the heading on two rows to improve readability. This is known as a “2-Level Header”.

The following example shows cases sold for three Root Beer brands over six months. Start with a Tabular view, and then change to the Report view. Remember to include a title for this Report and keep the totals on top. Notice how “Root Beer” repeats.

To add a 2-Level Header
to the report:

1. Unlock the Report.

2. Make room for a 2-Level Header by moving the three Summary Name items down.

a. In the Edit Item dialog for A&W Root Beer Cases (double-click on column heading), select the Breaklevel tab.

b. Verify the Location is set to Head 2. Then set the Index value to 2.

c. Repeat for each Summary Name item.

3. Create a new text item labeled Root Beer Cases above the three Summary Name items.

a. Select the Add Item button on the Report Edit Toolbar, third from the left.

b. Type in Root Beer Cases on the Data Tab.

c. On the Breaklevel tab, set the Location to Head 2, leaving the default Index value of 1.

d. On the Position tab, set the Column value to Column C (Column C is the middle column of the three summaries). You may also need to adjust this column’s position by setting the Horizontal Offset property. Test the offset by typing 14. Adjust.

4. Edit the Summary Name items.

a. In the Edit Item dialog for A&W Root Beer Cases, select the Data tab.

b. Change the Item type to Text, then label the item A&W.

c. Repeat for Barg’s and Mug.

5. Edit Text Fonts and Sizes as needed on the style tab.