|
Official Course
Description: MCCCD Approval: 5-24-2005 |
|||||
|
CIS112DA
2005 Fall – 2011 Summer II |
L+L 3.0 Credit(s) 4.0 Period(s) 3.7 Load Occ |
||||
|
Report Generator: Crystal Reports |
|||||
|
Build a variety of end-user reports using report wizards and templates. Enhance reports by using formatting, formulas, and graphics. Explore data, reports, and chart types. Create customized reports using custom templates, parameterized reports, and exporting options. Prerequisites: None. |
|||||
|
Cross-References: BPC112DA
|
|||||
Go to Competencies Go to Outline
|
MCCCD Official Course Competencies: |
|
|
|
|
|
CIS112DA 2005 Fall – 2011 Summer II |
Report Generator:
Crystal Reports |
|
1. |
Identify main components of a report. (I) |
|
2. |
Connect to data sources and run reports. (I) |
|
3. |
Explore online documentation. (I) |
|
4. |
Identify the various report types (II) |
|
5. |
Create reports using the wizards and templates. (III) |
|
6. |
Format reports using the Format Editor. (IV) |
|
7. |
Customize reports using formulas and Structured Query Language (SQL). (V) |
|
8. |
Enhance reports using embedded graphics, sub-reports, and drawing tools. (VI) |
|
9. |
Use Data Explorer and Report Explorer to view data and reports. (VII) |
|
10. |
Explore charts types. (VIII) |
|
11. |
Export reports to various applications. (IX) |
|
12. |
Create customized templates and parameterized reports. (X) |
Go to Description Go to top of
Competencies
|
MCCCD Official Course Outline: |
|
|
|
|
|
CIS112DA 2005 Fall – 2011 Summer II |
Report Generator:
Crystal Reports |
|
I. Crystal Reports Overview A. The main components of a report B. Connecting to a data source C. Running a report D. Online documentation II. Report Types A. Mailing labels B. Sub-reports C. Drill-Down III. Creating reports A. Report Design Wizard B. Using Templates C. Sorting, Grouping and Totaling results IV. Formatting report A. Guidelines and rulers B. Report and page footers C. Format Editor D. Use both absolute formatting and conditional formatting V. Using Formulas A. Formula Workshop B. Explore Structured Query Language (SQL) Expression Editor VI. Enhancing reports A. Embedding graphics B. Creating sub-reports C. Drawing tools VII. Exploring tools A. Data Explorer B. Report Explorer C. Template Explorer VIII. Explore chart types A. Bar B. Line C. Pie IX. Exporting Reports A. Export to spreadsheets B. Export to Portable Document Format (PDF) C. Export to Rich Text Format (RTF) D. Email reports X. Customization A. Custom templates B. Parameterized reports D. Export |