Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - Crystal Reports

Home

distance-learning center

Computer-Device_Tethered-Distance-learning Distance-learning-Building

Professional Distance-learning

IT Training Services



PCDBS07

Crystal Reports
DURATION: 3 days

FEE: $1,185

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.

AUDIENCE:

  • Business Professional
  • Programmer
  • Web Developer
  • Database Administrator
  • IT Professional
 
   

DATES:

CONTENT AND OBJECTIVES:
    1. Getting Started
      • Become familiar with the Crystal Report environment.
      • Process the main explorers and wizards.
      • Generate a simple report from a database.
    2. Text Objects
      • 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.
    3. 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.
    4. 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.
    5. Formulas
      • 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.
    6. Custom Functions
      • 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.
    7. Repository
      • 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.
    8. 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.
    9. 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.
    10. Sections and Areas
      • Create complex drill-down reports.
      • Format a section with the Section Expert and develop a summary report with drill-down capabilities.
    11. Analyzing with Cross-tabs
      • Create and format a cross-tab report.
      • Change the default formatting.
    12. Creating Charts
      • 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.
    13. Subreports
      • Drill-down on a subreport.
      • Create a static subreport.
      • Create a linked subreport to provide real-time information.

 
 
    Web-based Training   Blended Learning    
Synchronous
Instruction
Asynchronous
Instruction
 

 

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.