Crystal Reports Training Submit Crystal Reports Questions SYS-ED SYSED

Crystal Reports Training Services

Bookmark this page

Submit Crystal Reports Questions

Contact You

Crystal Reports Skillset Assessment

Knowledge Base

Enrollment

Crystal ReportsTraining

Report Generation,
Data Presentation, and Dashboards

Internetworking

Web Servers

Internet Programming

Crystal Reports Run Time Engine and Development Platform	Crystal Reports Training Experts	Knowledge Transfer Experts
Learning Paths	Courseware for Teaching	Grow Your Own Crystal Reports Programmers
Portfolio of Clients	Industry Standard Crystal Reports Courses	Tailored Crystal Reports Training
Database and XML Courses	Caveat Emptor	Why SYS-ED for Crystal Reports Training
Crystal Reports Training in New York	NYS Dept of Education Standards	Technology Exchange Websites
Technology Driven IT Training	Delivery Medium	Web-based Training Services

Courseware for Teaching

Cloud Computing - Crystal Reports and Scalable Databases

Crystal Reports
Schedule

Cost
Analysis

Sitemap

Crystal Reports is a registered trademark of SAP BusinessObjects.
DB2 is a registered trademark of IBM Corporation.
Access, Visual FoxPro, SQL Server, and .NET are registered trademarks of Microsoft Corporation.
Oracle database is a registered trademark of Oracle Corporation.
Sybase SQL is a registered trademark of Sybase, Inc.

Crystal Reports Runtime Engine and Development Platform

A challenge common to organizational enterprise is how to manage its databases and utilize data as part of its information technology infrastructure and as part of the product and services presented to clients. Since the mid 1980's Crystal Reports has been widely used by Fortune 1000 companies, government municipalities, and healthcare providers for report generation and database programming. Crystal Report software can be integrated into both .NET IDEs and Java. Developers can avail themselves of a single uniform reporting technology for data presentation and information delivery.

The Crystal Reports runtime engine is popular among software developers because it:

is lightweight and embeddable.
supports both .NET and Java applications.
supports both thick client and web applications.
supports the major web browsers - Internet Explorer, Firefox, and Safari.
is not dependent on a database for functions.
is has a familiar and easy to use report designer.

From this foundation, it has been a logical progression for organizational enterprise to use Crystal Reports software for implementing dashboards to monitor and measure data and provide a user interface for managing key metrics. These capabilities can be enhanced by using Crystal Reports Server to create, share, and deliver content over the Internet.

Crystal Reports and Microsoft .NET
Crystal Reports is installed with Visual Studio .NET. Microsoft licensed Crystal Decisions to write a version of Crystal Reports to serve as the default reporting system for .NET. Built into the IDE, Windows developers are provided with the tools for coding interactive integrated reports. The MS .NET platform treats every report as an object-oriented class. The entire object model is exposed to a .NET program; this is a very efficient way to modify reports. The object model can be accessed by any of the .NET languages: ASP.NET, VB.NET or C#.

There are three ways to use the Crystal Reports object model.

Utilization with the Object Model	Explanation
ReportDocument class	References each class and property of the report.
Methods and properties of the CrystalReportViewer control	The viewer has a subset of properties and methods. It provides the capability to modify the properties that effect logging in to a data source, setting report parameters, and deciding which report to preview.
Subscribing to events	The object model can be used for subscribing to events that are triggered while the report is previewed and printed.

Crystal Reports and Open Source Java
Crystal Reports for Java streamlines the manual generation of HTML code. A visual designer is used for connecting to data and transforming it into dynamic report templates. A visual drag-and-drop data explorer simplifies JDBC data connectivity. There are extensive formatting options for providing a rich end-user experience within a zero-client footprint. Crystal Reports embeds dynamic data into JSP pages and utilized in conjunction with a Java IDE, new or existing report files can be added to projects as resources. Subsequent management of code can be performed through a project and deployed with web applications. Built-in wizards produce clean code and eliminate tedious coding of functionality. There is also Crystal Reports for Eclipse, which includes an Eclipse plug-in that can be used for formatting reports to both thick and thin client Java applications.

Crystal Reports Training Experts
SYS-ED staff and technology partners have been consulting and training on Crystal Reports since its development by Crystal Services, Inc. (Releases 1 - 3), its purchase by Seagate (Releases 4 - 9) and its ownership by BusinessObjects (Releases 10, XI and XIR2) up through its acquisition by SAP. SYS-ED teaches industry standard and tailored client specific Crystal Reports courses augmented with content from the CETi knowledge base. We provide training on the across the Crystal Reports software product line: Crystal Reports Standard, Crystal Reports Professional, Crystal Reports Developer, Crystal Reports Advanced Developer, and Crystal Reports Server.

Equally as important, we are recognized experts on Crystal Reports and the underlying database engines and proprietary and open source web server development platforms. And yes, we teach and demonstrate the nuances and provide guidelines on utilizing XML data with Crystal Reports also. Few independent training companies have been teaching Crystal Reports longer or better than SYS-ED.


The foundation underlying the quality of the SYS-ED Crystal Reports training service is built upon:
1.	Expertise in Crystal Reports Application Development and Deployment Our system consultants are recognized experts in the architecture, protocols, and code that serve as foundation of Crystal Reports software. We have multi-disciplinary skillsets with proprietary Microsoft .NET and open source Java.
2.	A Crystal Reports and Database Courseware Library SYS-ED Crystal Reports courses extend the source software company documentation with sample programs, skeleton programs, and development guidelines. Our Crystal Report curriculum includes walkthroughs and integrated exercises with proprietary database software: MS Access, MS Visual FoxPro, MS SQL Server, Oracle, Sybase, and DB2 UDB.
3.	Qualifying a Crystal Reports Training Assignment SYS-ED will not accept an assignment until our Director of Education reviews the software environment and operational requirements with the prospective client. We will then compare it to our standard outline and performance objectives, and if required, develop client specific examples and workshops.
4.	Identifying and Providing Crystal Reports Educational Solutions SYS-ED recognizes and differentiates between providing an industry standard Crystal Reports course: Crystal Reports: Report Design and Crystal Reports for Visual Studio .NET as compared to "educational consultancy": Crystal Reports: Report Integration for VB Developers, and Crystal Enterprise SDK Development.

Technology Driven IT Training

Experts in Interrelated
Information Technology

Technology Updates

Crystal Reports Technology Update DB2 Technology Update Internetworking and MS Networks Technology Update

Java Technology Update MS SQL Server Technology Update .NET Technology Update

Oracle Technology Update WebLogic Technology Update XML Technology Update

Learning Paths

Crystal Reports Databases

Business Applications Web Design

XML Java

WebSphere WebLogic

Oracle DB2

Crystal Reports Training Services Advanced search

In order to review and print course topics, prices, invoke the search button.

Courseware for Teaching

The Crystal Report courseware and training aids provided as part of the SYS-ED training service are highly regarded in information technology. SYS-ED's long-term strategy is to have our courseware reviewed and recognized as a NRV: Nationally Recognized Vendor.

Crystal Reports	Crystal Reports for Visual Studio.NET	MS Access: Introduction
Table of Contents	Table of Contents	Table of Contents
Copyright Acknowledgement	Copyright Acknowledgement	Copyright Acknowledgement
Performance Objectives	Performance Objectives	Training Aid
Chapter 1	Chapter 1	Performance Objectives
Chapter 2	Chapter 2
Reference Card	Glossary
Workshop	Workshop
Index	Index

MS Access: Advanced	MS Access: VBA Programming	MS Visual FoxPro for Users
Table of Contents	Table of Contents	Table of Contents
Copyright Acknowledgement	Copyright Acknowledgement	Copyright Acknowledgement
Training Aid	Performance Objectives	Performance Objectives
Performance Objectives	Chapter 1	Chapter 1
	Chapter 2	Chapter 2
	Index	Index

MS SQL Server: Implementation and Administration	Delphi Programming	Delphi Programming: Advanced
Table of Contents	Table of Contents	Table of Contents
Copyright Acknowledgement	Copyright Acknowledgement	Copyright Acknowledgement
Performance Objectives	Performance Objectives	Performance Objectives
Chapter 1	Chapter 1	Chapter 1
Chapter 2	Chapter 2	Chapter 2
Index	Index	Index

Oracle PL/SQL Programming	Oracle PL/SQL Programming - Advanced	Oracle Application Development and Tuning
Table of Contents	Table of Contents	Table of Contents
Copyright Acknowledgement	Copyright Acknowledgement	Copyright Acknowledgement
Performance Objectives	Performance Objectives	Performance Objectives
Chapter 1	Chapter 1	Chapter 1
Chapter 2	Chapter 2	Chapter 2
Index	Index	Index

DB2 QMF: Query Management Facility	DB2 UDB Application Programming	DB2 UDB Application Programming - Advanced
Table of Contents	Table of Contents	Table of Contents
Copyright Acknowledgement	Copyright Acknowledgement	Copyright Acknowledgement
Performance Objectives	Performance Objectives	Performance Objectives
Chapter 1	Chapter 1	Chapter 1
Chapter 2	Chapter 2	Chapter 2
Index	Index	Index

Grow Your Own Crystal Reports Programmers

Over the past year, we have had a number of inquiries regarding whether SYS-ED still offered Crystal Reports courses for business professionals, webmasters, and IT professionals.

The typical comments were:

1.	That it is extremely difficult to find Crystal Reports training which provides the foundation and develops the specialized skills required for specific development and maintenance tasks.
2.	That there is a scarcity of fast-track Crystal Reports courses, 5 or fewer days in duration, geared to the employees from Fortune 500 companies, government, and healthcare providers.
3.	That a high percentage of Crystal Reports courses are cancelled.
4.	That travel costs and living expenses in a majority of situations are a significant constraint when it comes to attending a Crystal Reports course.
5.	That it is important to have a resource for asking Crystal Reports questions once the database training is complete.

In response to these questions:
	Yes, SYS-ED offers specialized Crystal Reports training: report generation, administration, programming, and tailored training.
	Yes, since the mid 1980's, SYS-ED has taught fast-track Crystal Reports courses and scalable database courses.
	Yes, we have the flexibility and resources to provide personalized training for small groups. We very rarely cancel Crystal Reports courses.
	Crystal Reports courses are available in multiple formats: classroom, distance-learning and blended web-based delivery.
	Upon completion of a SYS-ED course, our staff is available to answer Crystal Reports questions.

Portfolio of Crystal Reports Clients

Portfolio of Database Clients

Portfolio of Java Clients

Portfolio of Microsoft Clients

Portfolio of Oracle Clients

Portfolio of .NET Clients

Portfolio of XML Clients

Consultancy Derived Crystal Reports Training

SYS-ED’s Crystal Reports courses have been developed based upon the application of adult learning theory and the standards of the New York State Department of Education. The courses teach industry standard content augmented with consultancy derived techniques for database design, coding, and performance optimization.

SYS-ED provides Crystal Reports training on the major development platforms:

Crystal Reports
for Java

Crystal Reports
for .NET

Crystal Reports
for Oracle WebLogic

Crystal Reports
for Borland JBuilder

Information technology infrastructure is becoming increasingly hybrid and comprised of a combination of proprietary and open source software. Accordingly, it is our standard practice to qualify a prospective client's operating environment: web browser, operating system, web server, database, and middleware. We utilize this information to ensure that the examples, exercises, and training aids address specific operating objectives:

Transitioning from older versions of Crystal Reports to the SAP Business Objects model.

Migrating and upgrading applications from the client/server to the emerging service oriented architecture standard.

Logical and physical design in order to optimize performance of the source database engine.

Interface design and presentation format.

Exploration of dashboard functionality and requirements for development and implementation.

Utilization of the protocols serving as the foundation for web services in conjunction with Crystal Reports software.

Web development utilizing .NET and open source Java frameworks.

Interoperability of .NET and Java and identification of pitfalls.

At the client discretion, pre- and post- course validation assessment can be utilized for quantifying mastery of the subject matter. Upon completion of an instructor-led Crystal Reports course at the client location, it is standard policy to organize content for future utilization in a web-based training infrastructure.

When SYS-ED can not warranty a superior training outcome, then we will politely turn down an assignment.

Alternative to the IT Training
Offered by the Software Companies

Industry Standard Crystal Reports Courses

Crystal Reports	Crystal Reports: Advanced Techniques	Crystal Reports for Visual Studio.NET
You will learn: Crystal Reports screen elements. how to use text objects for displaying data. sorting and grouping data. incorporating geographic maps in reports. formulas for showing calculated data. how to use sections and areas. how to analyze data with cross-tabs.	You will learn: how to have Report Viewer interact with parameter fields. exporting reports to other formats. creating reports from SQL output. creating and using business views. reporting from OLAP cubes. creating and using subreports.	You will learn: how to design reports in Visual Studio.NET. delivering reports to the browser. building interactive web pages with ASP.NET. exporting reports to other formats. designing desktop applications. creating user interfaces. reporting from ADO.NET.

Tailored Crystal Reports Training and Educational Consultancy

These courses have been developed as a byproduct of consultancy assignments and in response to request by our clients.

Crystal Reports: Report Design	Crystal Reports: Report Design - II	Crystal Reports: Report Design - III
Crystal Enterprise Administration	Crystal Reports for Visual Studio .NET	Crystal Reports: Report Integration for VB Developers
	Crystal Enterprise SDK Development

Database and XML Courses

Microsoft Scalable Databases Courses
MS Visual FoxPro Programming	MS Visual FoxPro Programming - Advanced	MS SQL Server: Implementation
You will learn: how to implement event driven programming concepts. the Visual FoxPro programming environment. how to work with forms and form controls. how to utilize variables, arrays, and constants. creating and using subroutines and functions. creating custom menus. how to utilize text/input features. debugging and deploying applications.	You will learn: how to apply object oriented principles, properties, events, and methods. how to create and utilize classes. the screen builder. writing event handler code. adding OLE to an application. testing and debugging applications. how to optimize applications.	You will learn: defining supported data types. retrieving and modifying data. manipulating data. utilizing views. managing indexes. utilizing triggers. implementing defaults and rules. optimizing performance.

Open Source Databases Courses
ANSI SQL	Database Design	Data Modeling
You will learn: retrieving, adding, updating, and deleting rows in a table. table creation and administration. the functions of SQL transactions, logs, commits and rollbacks. how to code and use stored procedures.	You will learn: views, indexes, and physical storage. how to use composite and name attributes. identifying relationships and key attributes. when and how to denormalize. how to design and create data partitioning plans. storing duplicate data and repeating groups. guidelines for table creation.	You will learn: how data modeling and data mapping are used to represent business knowledge. data entities, attributes and associations used to represent business knowledge. how to identify business requirements for databases, Internet/intranet, and data warehousing projects. data modeling for forward engineering, reverse, and business reengineering projects.
MySQL - Introduction	MySQL: Administration	MySQL for Developers
You will learn: how to use client programs for accessing a MySQL database. creating, altering, and dropping a MySQL database. writing SQL statements for selecting data from a MySQL database. coding joins and subqueries. using SQL expressions. using SQL aggregate functions and scalar functions. inserting, updating, deleting, and replacing rows. creating and altering tables, indexes, and views. how to use transactions. granting and revoking access privileges on tables and views. importing and exporting.	You will learn: configuring MySQL. creating a database and managing tables. implementing a locking strategy. how to use storage engines. obtaining data from Information_Schema database. managing backup and recovery. utilizing stored procedures. managing users. implementing security-related configuration. optimizing queries and the server. setting and using the Event Scheduler. creating partitioned tables.	You will learn: managing the structure of databases and tables. managing and using indexes. importing and exporting data from within MySQL. performing joins for accessing multiple tables. coding and debugging subqueries. creating and using stored routines, triggers, and events. obtaining database metadata. optimizing queries and debugging MySQL applications.

XML Courses
XML: Introduction	XSLT: Transforming and Styling XML	XML: Programming
You will learn: creating well-formed XML documents. using XML namespaces. using XML schemas. creating and using DTDs: Document Type Definitions. using stylesheets with XML. processing XML events. using DOM: Document Object Model.	You will learn: navigating nodes using XPath. how to refine and combine stylesheets. programming with XSLT. creating and changing XML structure with XSLT. cross-referencing documents using XSLT. manipulating XML documents using SAX.	You will learn: creating and deploying XML documents. using a DTD to validate a document. how to create and use CSS2 compliant styles. using XSL: XML Stylesheet Language. using DOM: Document Object Model. program with SAX API.
MS VB.NET XML Web Services	MS C#.NET XML Web Services	Java Servlets, JavaServer Pages, and XML
You will learn: implementing a web service consumer. implementing a web service using Visual Studio .NET. web service architectures. how to use web service technologies - HTTP, XML, and SOAP. publishing and deploying a web service. securing a web service. designing a web service. implementing a non standard web service.	You will learn: creating and maintaining object oriented programs with C#. .NET XML web services. how to utilize XML schemas. the XMLTextReader class. how to understand and apply .NET and XSLT. how to build .NET XML web services. implementing security in .NET web services. how to create .NET web services.	You will learn: creating and maintaining J2EE web applications. using XML documents in web applications. DTDs for validating XML documents. Servlets. creating and using JavaServer Pages. how to create custom JSP tags. Java database connectivity. programming with SAX API.

Caveat Emptor
Prior to scheduling a Crystal Reports course from SAP, compare the quality of training service that SYS-ED offers with the alternatives:

Review the Crystal Reports and database learning paths.
Read the technology assessments and CFAQs - course frequently asked questions.
Examine the content in our Crystal Reports and database courseware and training aids.
Utilize our Crystal Reports and database skillset assessments.
Interview our instructor.

SYS-ED has been conducting courses in the public domain since 1980; however, there have been changes in the laws and regulations governing computer training in the state of New York. The schedule on our websites reflects a projected time frame for licensure with the New York State Department of Education - Bureau of Proprietary School Supervision and submission and approval of curriculum. It will be updated quarterly.

Why SYS-ED for Crystal Reports Training?

Get on the Fast Track .......

	Hands-on training	Web-based Training Services
	Superb courseware and training aids
	Crystal Reports Training in New York
	Resources to accommodate small groups
	Tailored private courses
	Warranty of Service
	Satisfied customers and industry testimonials
	Qualified training consultant for needs analysis and skills inventory
	Distance and e-learning

Web Development and
Internet Programming

Evolving IT - Interrelated Technologies

Information technology training for business enterprise is more complex and challenging than ever before. Organization’s have a working and substantial investment in infrastructure and applications specific to their operations. There are new industry standard protocols, web server and web enabled technologies, and development platforms which require a combination of development from scratch and integration with the existing client/server systems and enterprise databases. There are long term implications regarding the strategic mix of investing in proprietary and open source software, along with decisions on whether to maintain and upgrade the legacy applications, many now thirty or more years old, while retrofitting and transitioning to the new technologies. SYS-ED trained a significant portion of the first generation of DP and IT personnel. And look forward to training their successors in the 21st century.

.NET Training Program

Java Training Program

Oracle Training Program

Select a Database.

Selecting and invoking a database category will provide the courses for that category. Clicking on a title will provide the audience, duration, and course topics.
Scalable Database Software
Microsoft Access	ACT!	Crystal Reports
Visual dBASE	Visual FoxPro	Delphi
Enterprise Databases
DB2	Oracle	SQL Server
MySQL	PowerBuilder	Sybase

Crystal Reports Training in New York

Crystal Reports Courses
SYS-ED's Crystal Reports courses are tough, but they're worth it. Our challenging "hands-on" training provides a foundation and framework for Fortune 1000 companies, government municipalities, and healthcare providers to meet their staffing requirements and acquire specialized skillsets with Crystal Reports.¹

Courseware
SYS-ED's courseware draws upon our extensive library of database reports to demonstrate and teach Crystal Reports on the different development platforms (.NET and Java) and web server platforms.

Teaching is Our Business
Most computer training companies are divisions of large software or consulting companies. Not SYS-ED. Our only goal is to provide quality Crystal Reports training for motivated professionals - no more and no less. Because we're independent, we're free to concentrate on teaching - and since 1980 we have been doing it very well.

Our Teachers Know How to Teach
SYS-ED instructors combine teaching skills with broad practical experience as consultants. Our staff has been working with Crystal Reports since its initial release and average 30 years of experience in information technology:operating systems, database, web servers, and development platforms. Equally as important, we know how to teach. We teach not only "how to", but "why", building a solid foundation industry standard content and providing consultancy derived guidelines for advanced techniques. After a course, we are available to answer questions.

Enrollment - Crystal Reports Courses are NOT for Everyone
No one is allowed to enroll in a SYS-ED course, without a consultation with our Director of Education. We review the operational objectives and project specifications for the organization evaluating whether to send its employee for the training. The employee is ONLY allowed to register if they have the appropriate background corresponding to the correct learning path.

Crystal Reports Training in New York, at Your Office, or via the Web
SYS-ED courses are held at our modern, fully equipped training center in Manhattan and in conjunction with training partners in North America. If you prefer, we'll arrange tailored Crystal Reports training on-site at your organization’s facilities inclusive of mobile computer classroom set-up. On-site courses can include the identical workshops, case studies, and hands-on approach as the training we offer in New York.

For additional information including outlines, availability of private courses, references, and course customization, contact David Shapiro at our New York office at 212-564-9147 or register online.

Technology Exchange Websites
SYS-ED's technology exchange websites compile, organize, and present software specific and established operational categorizations of information technology. They provide a framework for assessing knowledge transfer in a variety of delivery formats: web based training, classroom instruction, technology updates, courseware, training aids, learning paths, and validation assessment.
http://www.crystalreportstrainingbysysed.us/commquests.htm
www.databasetrainingbysysed.us	www.dotnettrainingbysysed.us
www.db2trainingbysysed.us	www.oracletrainingbysysed.us
www.pcapplicationstrainingbysysed.us	www.xmltrainingbysysed.us

Footnote 1:
SYS-ED’s core Crystal Reports courses are being prepared for submission to the New York State Department of Education - Bureau of Proprietary School Supervision for technical review and licensing.