
Tips Recipes Brio 2002
Copyright © 2002, Brio Software Page 76
(Calendar-style Reports continued)
7) Finally, create a Report section to hold the final calendar.
• Place the Year_No field in Report Group 1, and both Month_No and Month_Name into
Report Group 2.
• Delete the Month_No field that appears in the group 2 header, leaving only the Month
Name. Move the Month Name to the top of the Group 2 header.
• Select the Year_No item in the Group 1 header, copy it to the clipboard and then paste
it into the Group 2 header. Move it to be underneath the Month Name, right-click on it.
Select “Properties” and change its Number format to be “###0”. Delete Year_No from
the Group 1 header.
• Select the Table object in the Report’s body and delete it.
• Select the Group 2 header, right-click and select “Keep Together” from the speed
menu. Then drag the formatted pivot into the Group 2 header area. Adjust the pivot’s
location within the Group 2 header as needed but do not change the vertical size of the
Group 2 header after inserting the pivot.
• You will notice that each month’s calendar is missing the bottom line. To add a floating
bottom line, drag a Horizontal Line object into the body area of the report. Size the line
to be the same width as the pivot. Use the cursor keys to place the line at the extreme
bottom of the pivot. (You may want to Zoom the report to check for exact placement of
the line.)
• Click on the horizontal line, then shift-click on the pivot in the same body section. With
both the line and the pivot selected, go to the main menu and use the Format | Spring
Objects menu item. This will set the line so that it will automatically float with the
pivot as the pivot changes height for each month.
Comentarios a estos manuales