CGS 2542

1
CGS 2542

• Tutorial 7
• Custom Reports

2
Northeast Seasonal Jobs International (NSJI)

• Task Create a Potential Income Report

Main report data
Subreport data
3
Customized Report Features

• Grouping Data
• Adding a Subreport
• Calculating Totals
• Adding lines

4
Additional Features

• Assign conditional values (true, false)
• Sort and group data
• Modify control properties
• Hide duplicate values
• Add calculated controls
• Use domain aggregate functions (DSUM)
• Add dates and page numbers
• Create mailing labels

5
NSJI Income

• Fee for each position filled
• Placement fee weekly wages 2
• Weekly wage hours per week wage
• One time fee based on openings filled
• 500 search fee for fewer than 3
• 200 search fee for 3 or more

6
Source Data

• Employer table
• NAICS table
• Position table

7
Additional Sources Required

• Need to create three queries
• NAICS and Employers query and the Potential
  Placement Fees query are already done for you
• Youll create the Potential Income by Employer
  query

8
Potential Income by Employer Query

• Source data for your query
• Total number of openings
• Total placement fees
• Total potential income
• Only for Employers who have available positions

9
Conditional Value

• IIf Function
• IIf (TotalOpeningsgt3, PlacementFee 200,
  PlacementFee 500)

10
Report
11
Custom Reports
Unbound Control using Label tool
Unbound Control using the Text Box tool
There can be seven sections
12
Controls and Captions
13
Calculated Fields
14
Zoom Dialog Box
IIf Function
15
Potential Income Calculated Field
16
Calculated Fields
17
Subreport Using Control Wizards
18
Calculate a Total
19
Potential Income
Adds 500 because less than 3
20
Can Grow/Can Shrink
Can Grow property With F4 function key
Can Shrink property set for the Subreport
21
Subreport
Conditional Format
Conditional Format
22
Mailing Labels
23
Mailing Labels
24
Mailing Labels
25
Review Assignment
26
Design View
27
Recruiters Report
28
Design View
Group Footer
Report Footer
29
Lets do Tutorial 7