Saturday, April 30, 2011

Parts Of A Report In MSAccess 2010

In Access, the design of a report is divided into sections. In a client database, you can view your report in Design view to see its sections. In Layout view, the sections are not as obvious, but they are still there, and can be selected by using the drop-down list in the Selection group on the Format tab. To create useful reports, we need to understand how each section works.  



The following list is a summary of the section types and their uses:

Report Header:   This section is printed just once, at the beginning of the report. Use the report header for information that might normally appear on a cover page, such as a logo, a title, or a date. When you place a calculated control that uses the Sum aggregate function in the report header, the sum calculated is for the entire report. The report header is printed before the page header.

Page Header:   This section is printed at the top of every page. For example, use a page header to repeat the report title on every page.
 
Group Header:  This section is printed at the beginning of each new group of records. Use the group header to print the group name. For example, in a report that is grouped by product, use the group header to print the product name. When we place a calculated control that uses the Sum aggregate function in the group header, the sum is for the current group. We can have multiple group header sections on a report, depending on how many grouping levels we have added. For more information about creating group headers and footers, see the section Add grouping, sorting, or totals.
 
Detail:   This section is printed once for every row in the record source. This is where we place the controls that make up the main body of the report.
 
Group Footer :  This section is printed at the end of each group of records. Use a group footer to print summary information for a group. You can have multiple group footer sections on a report, depending on how many grouping levels you have added.
 
Page Footer:   This section is printed at the end of every page. Use a page footer to print page numbers or per-page information.
 
Report Footer:   This section is printed just once, at the end of the report. Use the report footer to print report totals or other summary information for the entire report.

Here is an example of a report.




0 comments:

Post a Comment

Search This Blog

Followers

Related Posts Plugin for WordPress, Blogger...
Twitter Delicious Facebook Digg Stumbleupon Favorites More