Tutorial 7: Creating Custom Reports
Annotated Solutions
Case Problem 3
The RestaurantOrders query contains two
fields from the Donor table and four fields
from the Pledge table
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Custom Reports Tutorial 7: FundPledges Report - Custom Calculations & Formatting, Study notes of History of Education
This tutorial provides annotated solutions for creating a custom report named fundpledges, which includes a page header, detail, page footer, and report footer. The report displays data from the restaurantorders query, which has fields from both the donor and pledge tables. The page footer and report footer contain calculated controls that display the total pledges and the total of each pledge type. The detail section is formatted with singlespaced records and centered donorid values. The report sorts records in decreasing order by totalpledged and netpledge, hides duplicate totalpledged values, and formats the report to fit on one page. Additionally, a summary report named pledgessummary is introduced, which displays totalpledged and subtotal values in the group footer and the grand total in the report footer.
Typology: Study notes
Pre 2010
1 / 7
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download Custom Reports Tutorial 7: FundPledges Report - Custom Calculations & Formatting and more Study notes History of Education in PDF only on Docsity!
Tutorial 7: Creating Custom Reports
Annotated Solutions
Case Problem 3
The RestaurantOrders query contains two fields from the Donor table and four fields from the Pledge table
The Page Header section contains a report title, date, and page number
The FundPledges report includes four sections: Page Header, Detail, Page Footer, and Report Footer
The Page Footer section contains the student’s name, and the Report Footer section contains four calculated controls: one that displays the sum of all pledges, and three that display the total of each pledge type
The Detail section contains three Fund fields and a subreport
The calculated controls in the Report Footer have a border
In the Pledges report, records in the Detail section are single- spaced, and the DonorID values are centered
The report sorts records in decreasing order first by TotalPledged and then by NetPledge
Duplicate TotalPledged field values are hidden
PledgesSummary is a summary report that displays the TotalPledged and subtotal values in the Group Footer and the grand total in the Report Footer