- Set the Summary Running radio button to Group
- Click on the browse button at the extreme right of the Format string field
Format Cell Content and Close
- Select Currency
- Select the Custom tab
- Choose the $ 0 format
- Click on the OK button
Close Summary Editor
Click on the OK button.Note that the cell content has become Sum([CH184_Level.Total Sales]).
Repeat Process for CH184_Level.Gross Profit Cell
Repeat the above process for the CH184_Level.Gross Profit cell.
Format Subtotal Cell Content
- Select the two subtotal cells by drawing a rectangle that includes both while holding the left mouse button down
- Format the text as Arial, 12px, Bold, Right justified
Render Subtotal Cell Borders Visible and Eliminate White Space
- Select the Borders option in Property Grid, which is the lower left pane
- Open the drop-down menu by clicking on the down-pointing triangle at the extreme right of the field
- Click on All to render all cell borders visible
- Deselect the top border
- Drag the GroupFooter1 range lower border till it coincides with the lower border of the subtotal cell lower border to eliminate the white space below the footer in the final report
Begin Creating Report Totals
- Right click on the DetailReport - “CategoryName_Level” bar
- Select Insert Band
- Select “ReportFooter”. The result is a “ReportFooter1” bar appears.
Copy Subtotal Cells
Select both sum cells in GroupFooter1 and copy them by pressing Ctrl + C.
Paste Subtotal Cells in ReportFooter
Paste them into ReportFooter by selecting the ReportFooter range and pressing Ctrl + V.
Open Summary Editor
- Select the Sum([CH184_Level.Total Sales]) cell in ReportFooter
- Click on the small arrow above the upper right corner of the cell
- Click on the browse button at the extreme right of the Summary field
Set Summary Running and Open FormatString Editor
- Set the Summary Running radio button to Report
- Click on the browse button at the extreme right of the Format string field
Format Cell Data Content
- Select Currency
- Select the Custom tab
- Choose the $ 0 format
- Click on the OK button
Close Summary Editor
Click on the OK button. Repeat the above process for the Sum([CH184_Level.Total Sales]) cell in ReportFooter.
Format Report Total Cell Contents
Format the text as Arial, 14px, Bold, Right justified.
- Select the Borders option in Property Grid, which is the lower left pane
- Open the drop-down menu by clicking on the down-pointing triangle at the extreme right of the field
- Click on All to render all cell borders visible
- Drag the Report Total cell upper border till it coincides with the lower border of the ReportFooter bar lower border to eliminate the white space between the Category Subtotals and the Report Totals in the final report
Drag the ReportFooter range lower border up to coincide with the Report Total cell lower border to eliminate the white space at the bottom of the report.
Save Template
Click on the Save As icon in the Report group.
Name and Save to Specific Folder
- Make sure the Save As window is opened in the C:\NPrintingTraining\Templates folder, browse to it if not
- Enter a File name or accept the suggested one
- Click on the Save button
Preview Report
Click on the upper part of the Preview icon in the Report group.
Inspect Report Detail