Generating Reports excel 2007 Office 2007


Reports are a means to view and analyze large amounts of data. You can use the Report Wizard or create a custom report that meets your specific needs.

Report Views
Reports can be displayed in four views:


Design View This view provides you with the structure of your report. You can add, modify or delete components of the report but you cannot manipulate the data in the tables associated with the report.

Report View
This view allows you to view the data from the table but not to change any layout of the report.

Layout View
This view allows you to see data from the table and add, modify, and delete components of the report.

Print Preview
This view allows you to see what your report will look like when it is printed.


To change report views:

Click the View button on the Home tab

Create a Report
To create a blank report:

Click the Blank Report button on the Create tab

Click the Add Existing Fields button
From the field list, Click and drag the fields to the report

Report Wizard
To create a report using the report wizard:

On the Create tab, click the Report Wizard button


Choose the Tables/Queries that you wish to have on the form
Choose the fields you wish to have on the forms
Click Next


Choose the sort order for your report


Chose the layout for the form
Click Next


Choose a style
Click Next


Create a title for the form
Choose whether you want to open the form to view it or modify the form’s design
Click Finish


Custom Calculated Fields
You can create reports that include calculated fields. These reports will display information that you wish to report with an arithmetic calculation. To add a custom calculated field to a report:

Open the Report that you wish to add to
Click the View button
Click Design View


Click the Design tab
Click the Text Box button

Click the section on the report where you would like to locate the textbox
Click the Property Sheet Pane


Click the Data tab
Click the three dots next to Control Source

Insert the fields you wish to include in the calculation and the mathematical operations.
Click OK





source : http://www.fgcu.edu