Display Density
Note! Payment is due at time of registration.

Crystal Reports

XCDR 1000 - Crystal Reports 2008 Fundamentals

Explore the program environment, and learn how to open, navigate, create, modify, and save reports. Explore the basics of formatting report objects, of sorting and selecting records, and creating groups and summaries. Create simple formulas and functions and work with Crystal Reports' experts and wizards. Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Proficient with Microsoft Access and database concepts.

CEU Hours: 1.4

Contact Hours: 14

Course Outline:

Getting started
1)	The Crystal Reports environment
2)	Creating, viewing, and saving reports
3)	Modifying report layout
4)	The Help feature
Formatting
1)	Absolute formatting
2)	Introducing conditional formatting
Sorting and selecting records
1)	Sorting records
2)	Selecting records
Grouping and summarizing
1)	Groups
2)	Summaries
Formulas and functions
1)	Formulas
2)	Modifying formulas
3)	Functions
Experts and wizards
1)	The Database Expert
2)	Report wizards and templates
3)	Cross-tab reports
Distributing reports
1)	Exporting reports
2)	Delivering reports
 
CRN Days Time Date Location Instructor Seats Open
53338 005 --WR--- 08:00-03:59 PM 10/08/14-10/09/14 RC 252 Tuck L 9 of 10

XCDR 1001 - Crystal Reports 2008 Advanced

Learn how to create and use parameter fields, including interactive and cascading parameters. Build advanced formulas using variables, advanced functions, and constructs. Create and customize charts and maps, apply advanced formatting options to report elements, and create alerts and subreports. Learn about the Business Objects Enterprise Repository and advanced data access techniques including ODBC data sources and SQL query-building. Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Crystal Reports Fundamentals or comparable knowledge.

CEU Hours: 1.4

Contact Hours: 14

Course Outline:

Selecting data
1)	Parameter fields
Advanced formulas and functions
1)	Running totals
2)	Variables
3)	Advanced functions
4)	Constructs
Charts and maps
1)	Working with charts
2)	Creating maps
Formatting complex reports
1)	The Section Expert
2)	Advanced conditional formatting
3)	Objects
Alerts and subreports
1)	Report alerts
2)	Subreports
Advanced data access techniques
1)	ODBC data sources
2)	The Business Objects Enterprise Repository
3)	SQL and the Database Expert
 
CRN Days Time Date Location Instructor Seats Open
53339 005 MT----- 08:00-03:59 PM 11/10/14-11/11/14 RC 250 Tuck L 10 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.