PRIVATE GROUP FEE:
$ Based upon a class size of six students.
Scheduling can be adjusted to employee work hours and incorporate client assignments.
SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.
CONTENT AND OBJECTIVES:
Viewer Interaction with Parameter Fields
Process and use parameters fields with the Viewer.
Create parameter fields for the Viewer and use the parameter fields in record selection.
Export data and reports into different file formats.
Export data to MS Excel and MS Access applications and an XML file.
Reporting from SQL Databases
Process data from an SQL database using stored procedures.
Invoke SQL stored procedures and process the return resulttable.
Create and use Business Views
Learn how to use Business Views Objects and Business View Manager.
Use Data Connection and Dynamic Data Objectives.
Manage reporting across multiple data sources and applications by simplifying data access, change management, and data-level security processes.
Integrate data from disparate sources and handle the promotion and demotion between development and production environments.
Learn how to control security at both the row and column level.
Build connections to multiple data sources, join tables, and alias field names.
Create calculated fields and then present this simplified structure as a Business View in Crystal Enterprise.
Database Changes and Field Mapping
Understand processing logic when a database changes.
Reporting from OLAP Cubes
Utilize a cube for accessing a multidimensional representation of business facts required to efficiently present data.
Reporting from Proprietary Datatypes
Using XML data as the database, input the XML, display the information, and export the information as a report.
Crystal Reports with ASP and ASP.NET
Learn how to interface ASP.NET with Crystal Reports.
Use ASP.NET for coding a web application which will display multiple reports.
Crystal Reports with Java
Interface Java applications or applets with Crystal Reports.
Use Java for coding a web application which displays multiple reports, including reports with parameters supplied by the user.
Develop reports using multi-tier reporting methods.
Develop reports using the Crystal Enterprise Multitier Reporting Method.
Crystal Launchpad and Web Desktop
Navigate the Crystal Enterprise Launchpad.
Connect to the web desktop, navigate to the appropriate location, and select a series of reports for viewing.
Organize the web desktop.
Administering Crystal Enterprise
Learn how to configure Crystal Enterprise.
Configure the system for alert notification which will be sent to the user who has exceeded the threshold statistic.
Report Designer Component
Learn how to use the RCD: Report Designer Component for creating reports in Visual Basic.
Use Visual Studio for invoking the RCD to create a detail listing, summary report, and chart for the supplied database.
Create linked sub reports and linking based on formula fields.
Create sub reports based on formulas and allow the Viewer to drill down the reports.
Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.
Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.
SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.