CHAPTER 6 BUILDING REPORTS
Once you have grouped the data that will be in the report, the next two screens are primarily for
formatting. Here, you can specify whether you want the report to have a stepped or block layout, as well
as whether the report will include subtotals and provide drill-down functionality. You can also choose a
custom style for the report.Figure 6-2. Report Wizard group and details selectionsFor now, choose Stepped with No Drill-Down functionality and click Next. On the Table Style
screen, apply the Corporate style to the report, click Next in the wizard, and change the name from the
default, ReportX, where X is the next number in sequence of created reports, to Employee Cost Report
Wizard. Next, check the Preview Report box to have the report executed upon creation, and then click
Finish to generate the report. After a few moments, the resultant report appears. Although at first glance
it appears to need many cosmetic changes, such as extending the size of the several columns (e.g.,
Employee Name and Diagnosis), resetting the background color of the groups to White, the font color of
[Year] to Black, and formatting the Estimated Cost column for currency, the report is at least functional.
Depending on the desired layout, it could need a good deal of work to get it the way you want it.
Assuming you accepted one of the default styles, this would be a good starting point for modification, as
shown in Figure 6-3.