Order By Display Density

Crystal Reports

XCDR 1002 - Crystal Reports 2011 Fundamentals

Explore the program environment, and learn how to navigate, create, and modify reports. Create formulas, prompts, and parameter fields and explore the basics of enhancing reports through formatting and grouping. Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Proficient with Microsoft Access and database concepts.

CEU Hours: .7

Contact Hours: 7

Exploring the SAP Crystal Reports 2011 Interface
1) Explore Crystal Reports
2) Use Crystal Reports Help
3) Customize the Report Settings
Working with Reports
1) Create a Report
2) Modify a Report
3) Display Specific Report Data
4) Work with Report Sections
Using Formulas in Reports
1) Create a Formula
2) Edit a Formula
3) Filter Data Using a Formula
4) Work with Advanced Formulas and Functions
5) Handle Null Values
Building Parameterized Reports
1) Create a Parameter Field
2) Use a Range Parameter in a Report
3) Create a Prompt
Grouping Report Data
1) Group Report Data
2) Modify a Group Report
3) Group Using Parameters
4) Create a Parameterized Top N Report
Enhancing a Report
1) Format a Report
2) Insert Objects in a Report
3) Suppress Report Sections
4) Use Report Templates
Creating a Report from Excel Data
1) Create a Report Based on Excel Data
2) Modify a Report Generated from Excel Data
3) Update Data in a Report Based on Excel Data
Distributing Data
1) Export Data
2) Create Mailing Labels
 
CRN Days Time Date Location Instructor Seats Open
93169 001 ---R--- 08:00-03:59 PM 10/29/15-10/29/15 RC 253 Tuck L 11 of 14

XCDR 1003 - Crystal Reports 2011 Advanced

Learn how to create complex reports and increase the speed and efficiency of your reports by using SQL queries. Work with the various tools that generate subreports, cross-tabs, charts, and running totals. Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Crystal Reports Fundamentals or comparable knowledge.

CEU Hours: .7

Contact Hours: 7

Creating Running Totals
1) Create A Running Total Field
2) Modify a Running Total Field
3) Create a Manual Running Total
Working with Cross-Tabs
1) Create a Cross-Tab Report
2) Format a Cross-Tab Report
3) Create Groups in Cross-Tab Reports
Adding Subreports
1) Insert a Subreport
2) Edit a Subreport
3) Share Variables
Creating Drill-Downs in a Report
1) Create a Drill-Down
2) Create Headings for Drill-Down Data
Using SQL Statements in Report Processing
1) Create a Report Using SQL Queries
2) Summarize Report Data
3) Create Joins Using SQL
4) Create Subqueries
5) Create a SQL Expression Field
Creating Complex Formulas
1) Work with Loops
2) Work with Arrays
Adding Charts to Reports
1) Create Charts
2) Create a Chart with a Drill-Down
3) Create a Top N Chart
4) Create a Cross-Tab Chart
5) Create Charts for Grouped Data
6) Format a Chart
7) Create a Chart Template
Enhancing Report Functionality
1) Organize Data Based on a Hierarchy
2) Create a Dynamic Image
3) Create a Report Alert
4) Create a Geographic Map
 
CRN Days Time Date Location Instructor Seats Open
93170 001 ---R--- 08:00-03:59 PM 11/19/15-11/19/15 RC 254 Tuck L 13 of 14
Clinic Courses (CLI) provide practical application and are offered on or off campus. Instructors supervise/direct student in a simulated or on-site setting.
Face-to-Face Courses (F2F) take place in a classroom. Based on JCCC's Statement of General Education. Students in all classes, including face-to-face classes, are expected to use technology appropriate to the course content and as needed to access web-based course materials. Face-to-face classes typically require access to computer equipment (either at home or in college labs provided for student use) and computing skills utilizing standard office, business and web browsing applications.
Hybrid Courses (HYB) combine face-to-face classroom instruction and the convenience of online web-based learning, resulting in a reduction of the amount of time spent in the face-to-face classroom and a significant increase of time spent studying online materials. Students registered in hybrid courses must attend class meetings as listed in the JCCC Schedule of Classes.
Internships (INT) provide experience to students for on-the-job training with cooperating businesses, agencies, and organizations. The number of hours for each internship varies.
Lab Courses (LAB) are face-to-face classes where students perform tasks as directed by faculty. Faculty members monitor the activity and provide individual and/or group instruction/assistance
Media Courses (MED) deliver all or a portion of instruction through either cable broadcast or pre-recorded video lessons. The videos are available in DVD format from the Billington Library.
Online Courses (ONLNE) use the Internet and a Learning Management System (D2L) to deliver course materials and to facilitate student-instructor, student-content, and student to student interaction. To participate in online courses, the student should have a good understanding of computer hardware and software applications and the Internet.
Continuing Education Online Courses (CEONL) and materials are delivered via the Internet. To participate in online courses, the student should have a good understanding of computer applications and Internet navigation. For more information about this course and other online learning options visit CE Online.
Private (PLV) lessons for credit are available from beginning to advanced in voice, piano, guitar, brass, woodwind and percussion. Lessons are scheduled by arrangement with private music instructors.
Self-Paced Courses (SEL) and Self-Paced Online (SPO) are offered on a schedule of study that allows students more flexible scheduling options. Course interaction is based upon a contract between student - instructor and in some cases can take up to one calendar year to complete. Some courses may use online delivery to facilitate the learning experience.
Self-Paced Courses (SEL) and Self-Paced Online (SPO) are offered on a schedule of study that allows students more flexible scheduling options. Course interaction is based upon a contract between student - instructor and in some cases can take up to one calendar year to complete. Some courses may use online delivery to facilitate the learning experience.
Travel Courses (TRV) may require in-class activities as well as traveling to a destination. Students will be responsible for the cost of the travel as well as the course costs.
Seats Open is an approximation of the number of seats available and may not represent the actual number of seats open at the time of registration.
This course is approved by the Kansas Board of Regents for guaranteed transfer among all Kansas public postsecondary institutions. Additional courses may also be eligible for transfer. Please visit the JCCC Registrar to learn more.