ExA-6
3. Move Material column next to the Dia/Ht column.
4. Drag the right report edge marker to 8 1/8” (to reduce line size and Header
information.)
5. Reduce the width of the Report Subtitle box to 7”.
6. Increase the width of the Title box to 7”.
7. Change the title to “Sewer Pipe Sizes for Material Types”.
8. Change the Page Setup to Portrait.
9. Center the page number.
10. Group on Material (NT_MAT_TY).
11. Group on Diameter (NT_DIA).
12. Count the number of pipes for the Diameter group.
a. Click on the Pipe ID field (NT_ID).
b. Click on Insert Summary.
c. Set the summary to Count.
d. Set the Location to Group 2 (Diameter).
e. OK
13. Increase the Group Footer 1 section to 3”.
14. Insert Chart into the Group Footer 1 section.
15. In Chart Expert under Type, select Doughnut.
16. In Chart Expert, Data tab, Select Group Layout.
17. Confirm the Data as On change of Diameter (NT_DIA) Show the count of the pipe ID
(NT_ID).
18. In Chart Expert under Text, change the Title to read Percent of Pipe Diameter.
19. Suppress Group Headers 1 and 2, Detail and Group Footer 2 sections.
20. Remove the column headers and line beneath them.
• Close up the Page Header to about 1”.
21. Change the Graph Subtitle font.
a. Click on the graph Subtitle (For @NT_MAT_TY).
b. Right click and select Format Subtitle…
c. Change to Bold and Color Black.
d. OK
22. Remove the value in the Center of the doughnut.