Crystal Reports Fundamentals (First 2 Courses) VILT

$790

Clear
SKU: N/A Category: Tags: , , ,

Description

Crystal Reports (ver. 2008 and Newer) Fundamentals (First 2 Courses) VILT


COURSE 1

Class Type:  2 Day Virtual Instructor Led Course Summary

This course is used to enhance basic report writing skills. Students will learn how to interface with databases, format a report, build groups, develop conditional formatting to enhance your reports, and filter the records using select expert. Learning Crystal Reports on your own could be a very overwhelming experience as there are various reports, databases, and dynamic data. This course will guide students through the process to understand all of the important concepts. After this course, students will then feel very comfortable using reporting and analyzing data. Experienced students find this course to be very enlightening because there are many features they haven’t previously used that will enhance reports and increase productivity. (NOTE: If you do not have the application installed on your computer, please call for help in installing an evaluation version.)

Concepts Covered
  • Simple Report – Create New Report, Window Sections, Field Explorer, Design/Preview/Refresh, Menu bar, DB Expert, Report Explorer, Record Sort, Insert Text Object, Placement of fields, Arrows on keyboard, Resizing Fields, Size and position, Select all section objects, Make Same Size, Aligning Objects, Browse data, Fields in Text Boxes, Right Pane Layout, and Status Bar.
  • Format – Format toolbar, Format Dialog box, Border tab, Font tab, Read Only, Lock Position / Size, Text Rotation, Can Grow, Format Data Types, Add Box, Add a Line, Add a Picture, Special Fields, Modification Date, Page N of M, and Print Date.
  • Select Expert – Select Expert Icon, String Based Criteria, Number Based, Time Based Criteria, Boolean Based, Show Formula, and Multiple Criteria.
  • Grouping – Insert Group, Group Expert, Group Sorting, Group Options, Multiple Groups, Group Tree, Insert Summary, Grand total, Operators, Additional Summary, Calculating Percentages, Group by date.
  • Database Expert – Database Expert Icon, DB Expert Options, Auto-arrange button, Link button, Clear Links, Delete Link, and Index Legend.

 

COURSE 2

This course is used to enhance basic report writing skills. Students will learn how to interface with databases, build formulas to fix problems, as well as charting and export capabilities. Learning Crystal Reports on your own could be a very overwhelming experience as there are various reports, databases, and dynamic data. This course will guide students through the process to understand all of the important concepts. After this course, students will then feel very comfortable using reporting and analyzing data. Experienced students find this course to be very enlightening because there are many features they haven’t previously used that will enhance reports and increase productivity. (NOTE: If you do not have the application installed on your computer, please call for help in installing an evaluation version.)

Concepts Covered

  • Formulas – Formula Syntax, Special Characters, Data Types, Operators, Formula Workshop, Check Formula, Help, Formula Editor, Auto-complete, Number Calculations, Line formula, Sum Function, ToNumber, Date Calculations, CurrentDate, ToText, Year, Month, Day, Date Formulas, Boolean Formulas, String Concatenation, If Then Else Formulas, String Formulas, ToText, Left, Right, Mid, Length, Picture, IsNull, and Not IsNull.
  • Conditional Formatting  – Highlight Expert, Conditional Formatting, Section Expert, Suppress, Page Before, Color, and Alternating Lines.
  • Charts – Insert Chart, On Change of, Chart Value(s), Chart Expert, Axis, Color Highlight, Format Chart, Format Background, Chart Options, Appearance, Titles, Data Labels, Legend, Gridlines, Axis, and Format Chart Objects.
  • Export – Export Feature, Adobe (PDF), MS Excel 97-2000, and MS Excel 97-2000 (Data Only).

Additional information

Date

Course 1 – Thursday, August 10th, 2017 and Course 2 – Friday, August 11th