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:
Become familiar with the Crystal Report environment.
Process the main explorers and wizards.
Generate a simple report from a database.
Design and process text fields in a report.
Become familiar with security in SQL Server and integrated security with the MS Windows family of operating systems.
Perform the following: 1- create fields. 2- Change the heading. 3- Format the fields and the heading. 4- Concatenate fields. 5- Modify parts of a text field.
Sorting and Grouping
Sort the resulttable and produce reports with breaks and summarized data.
Produce reports sorted by multiple fields.
Print reports with summary information and summary and detail information.
Display a report in which the user can drill down to the data.
Creating Geographic Maps (Optional)
Develop a map and process map requests from the user.
Create a map and allow the user to drill down to sub regions of the map.
Create formulas for calculating values and producing custom displays.
Use the formula editor and the formula expert for creating calculations.
Perform date calculations and boolean formulas.
Calculate and display running totals.
Use built-in functions and create custom functions.
Create a custom function to be placed in a library and which can be shared with other developers.
Create a centrally managed location from which report designers can access, update, reuse, and share report objects; the Crystal Repository is a stand-alone database; MS Access is the default database.
Create a folder and then delete items from the repository.
Display a list of the objects in the repository.
Analyzing with Advanced Selection Criteria
Become familiar with the Selection Expert.
Select records based on boolean logic, date range selection, range selection, and specified summary information.
Visual Appearance of Reports
Format reports for visual impact and conditional formatting.
Conditionally add fields based on values in other columns.
Use the Highlighting Expert to emphasize rows of data based on a condition.
Use the Format Painter for formatting a report.
Sections and Areas
Create complex drill down reports.
Format a section with the Section Expert and develop a summary report with drill-down capabilities.
Analyzing with Cross-tabs
Create and format a cross-tab report.
Change the default formatting.
Become proficient creating charts.
Use the Chart Expert to create a pie and bar chart which displays summary information.
Allow the user to drill down through the pie chart.
Drill down on a subreport.
Create a static subreport.
Create a linked subreport to provide real-time information.
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.