8
Generating a Paper Report

Estimated Completion Time: 15 minutes

This chapter describes how to create a paper version of the Web report you just created. Here, you will use the Report Wizard to create a paper layout using the same data model you created in Chapter 2, "Adding Data to a Report".

If you already know how to use the Report Wizard, refer to Appendix A.4, "Entries for the Report Wizard"for a quick reference guide.

Figure 8-1 Generating a Paper Report from a JSP-based Web Report Data Model

Text description of the illustration paper_xg.gif

8.1 Generate a paper report based on your data model

In this section, you will learn how to generate a paper layout based on the same data model you created in Chapter 2, "Adding Data to a Report".

Note: You must be connected to the same database you used, and access the Human Resources schema. If you do not know the connection information for the database, contact your database administrator.

To generate a paper report: using the Report Wizard:

1. In the Object Navigator, make sure the report you created in Chapter 6, "Creating a Graph for the Web Report" called emprevb_<your initials>.jsp is open.

   Note: If you don't want to create a JSP-based Web report first, and just want to learn how to generate a paper layout for a JSP-based Web report, open the file we've provided, called emprevb.jsp.

2. In the Object Navigator, right-click the report name.

3. From the pop-up menu, choose Report Wizard.

4. Let's choose the Paper Layout since we're generating a paper report. We don't need to select a Web Layout since we've already done that in Chapter 3.

   In the Report Wizard, on the Report Type page, select the Create Paper Layout only radio button.

5. On the Style page, select the Group Above radio button.

6. Click the Data tab.

   The data model you created in Chapter 2, "Adding Data to a Report" should display in the SQL Query Statement text box.

7. On the Fields page, move the following fields to the Displayed Fields list by selecting the field, then clicking the right arrow.
   • emp_name

   • mgr_name

   • SumSALARYPerReport

   • SumSALARYPerReport1

   • SumSALARYPermgr_name

   • SumSALARYPermgr_name1

   • SALARY

8. On the Totals page, in the left-hand list, click SALARY, then click Sum.

9. On the Labels page, in the Label field for the mgr_name field, type Manager Name.

10. In the Label field for the emp_name field, type Employee Name. Update the other Label names as you wish.

11. On the Template page, select the Beige radio button to select the template.

12. Click Finish.

    The report displays in the Paper Design view, and should look something like this:

Figure 8-2 Final Paper Report

Text description of the illustration paper_fin.gif

Choose File > Save As.

Change the name to emprev_paper_<your initials>.rdf, and make sure "rdf" is selected.

Click Save.

8.2 Summary

Congratulations! You have now generated a paper report based on the data model you created for a JSP-based Web report. You now know how to:

• Open the Report Wizard for an existing JSP-based Web report

• Create a paper layout for your report

• Produce a paper version of your Web report

For more information on generating a paper report based on an existing data model, see the Reports Builder online help.