CRYSTAL REPORT LEVEL 1

Organizations use reporting tools to access data sources and generate customized reports. Crystal Reports 2013 enhances report building and report processing techniques with a variety of features that add value to a presentation. In this course, you will create a basic report by connecting to a database and modifying the report's presentation. 
Information is critical to making sound business decisions. Data presented without any formatting or structure holds little or no meaning for interpretation. Crystal Reports 2013 helps you build advanced reports with ease, presenting complex information in an understandable way. 

 

Course Objectives:


In this course, you will connect to a database to extract data and present it as a report. 
 

You will:


Identify the elements of the Crystal Reports interface. 
Create and modify a basic report. 
Use formulas to calculate and filter data. 
Build a parameterized report. 
Group report data. 
Enhance a report. 
Create a report using data from an Excel workbook. 
Distribute data. 

 

Course Content


Lesson 1: Exploring the Crystal Reports Interface 
Topic A: Explore Crystal Reports 
Topic B: Use Crystal Reports Help 
Topic C: Customize Report Settings 

Lesson 2: Working with Reports 
Topic A: Create a Report 
Topic B: Modify a Report 
Topic C: Display Specific Report Data 
Topic D: Work with Report Sections 

Lesson 3: Using Formulas in Reports 
Topic A: Create a Formula 
Topic B: Edit a Formula 
Topic C: Filter Data by Using a Formula 
Topic D: Work with Advanced Formulas and Functions 
Topic E: Handle Null Values 

Lesson 4: Building Parameterized Reports 
Topic A: Create a Parameter Field 
Topic B: Use a Range Parameter in a Report 
Topic C: Create a Prompt 

Lesson 5: Grouping Report Data 
Topic A: Group Report Data 
Topic B: Modify a Group Report 
Topic C: Group by Using Parameters 
Topic D: Create a Parameterized Top N Report 

Lesson 6: Enhancing a Report 
Topic A: Format a Report 
Topic B: Insert Objects in a Report 
Topic C: Suppress Report Sections 
Topic D: Use Report Templates 

Lesson 7: Creating a Report from Excel Data 
Topic A: Create a Report Based on Excel Data 
Topic B: Modify a Report Generated from Excel Data 
Topic C: Update Data in a Report Based on Excel Data 

Lesson 8: Distributing Data 
Topic A: Export Data 
Topic B: Create Mailing Labels 

Appendix A: Setting Up and Configuring Data Sources 
Appendix B: Using Report Processing Techniques 
Appendix C: Using Functions in Formulas

Convenience and Quality instruction is our goal at John Mason Institute.

Available formats

Live in person instructor at our classroom or remote instruction in the traditional classroom style

 

 

Remote one on one  instruction for your convenience with our top quality teachers.

Instruction with a very flexible schedule

Do you need a class date and time not on the schedule or prefer the instruction be done at your location? Then please contact us and we work very hard to meet your needs.

GET MORE INFORMATION

CALL US NOW

603 879 0991

Full Placement and Temporary service available with
John Mason Services
Now Featuring CCNA, CCNP and CCIE Training
Photography Services available including Headshots

© 2023 by John Mason Institute /Hellenic College 
436 Amherst street , Nashua, NH 03063, USA

  • Facebook Round
  • Twitter Round
  • YouTube - Black Circle
  • Google+ - Black Circle
  • LinkedIn Round