Order By Display Density

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, 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
90335 001 MT----- 08:00-03:59 PM 02/23/15-02/24/15 RC 252 Tuck L 10 of 10
91317 002 MT----- 08:00-03:59 PM 06/22/15-06/23/15 RC 254 Faculty 14 of 14

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
90336 001 MT----- 08:00-03:59 PM 03/23/15-03/24/15 RC 253 Faculty 14 of 14
91318 002 MT----- 08:00-03:59 PM 07/20/15-07/21/15 RC 253 Faculty 14 of 14

XCDR 5001 - WB: Introduction to Crystal Reports

Want to "wow" people with your business reports? In this course, you'll master the techniques the pros use to produce attractive, reader-friendly reports for any audience. Designed for Crystal Reports XI, Crystal Reports 2008, and Crystal Reports 2011, this course will teach you how to transform the information that lies buried in your database or accounting program into clear, easy-to-understand documents. You'll hone your Crystal Reporting skills as you get hands-on practice in extracting, sorting, and grouping your data. In addition, you'll find out how to include totals for groups of figures or for the entire report. Next, you'll master the art of building your reports and formatting your material to create a polished, professional look. Whether you're new to Crystal Reports or want to enhance your skills, this course is ideal for you. By the time you're done, you'll be able to produce anything from a quick meeting handout to an elaborate annual report-and you'll never be intimidated by report-writing tasks again!NOTE: Please check the Requirements tab for important software version information before you sign up for this course.For more information about this online class and/or additional start dates, visit: http://www.ed2go.com/jccc/

Contact Hours: 24

 
CRN Days Time Date Location Instructor Seats Open
92087 501 CEONL ------- - 01/21/15-03/13/15 Online Faculty 100 of 100
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.