Who Should Use This Book
The study guide questions are aimed at Crystal Reports Designers and Developers preparing for the certification exams (BOCP), it also acts a knowledge-base for Beginners to Advanced users. Readers are advised to use this study guide in conjunction with hands-on-practice and classroom based courses, this will give readers a greater insight into the functionalities of Crystal Reports.
Topics Covered in This Book
Each chapter covers questions on the various sections of Crystal Reports utilization, functionality and development. Crystal Reports is an advanced Business Intelligence reporting software package, which provides users with exceptional reporting functionalities; which is utilized by many companies to achieve their reporting requirements. The study guide questions will test the reader’s knowledge of the functionalities within Crystal Reports and how these functions can be applied to various aspects of reporting to achieve specific goals. The content of some of the chapters are organised as follows:
Chapter 1: Create a Basic Report: In this chapter questions relating to connecting to a data source, adding tables, the design environment, creating a new report, inserting and positioning objects on a report, previewing and saving a report, applying a record selection and organizing data in a report are covered. This chapter consists of 264 questions.
Chapter 2: Customize and Format a Report: In this chapter questions relating to formatting objects, adding graphical elements, section formatting, creating a chart and applying report templates are covered. This chapter consists of 177 questions.
Chapter 3: Create a Formula: Questions in this chapter relate to the creation of formulas, using functions and operators which cover financial, date, maths, string, SQL expressions, control structures, variables and arrays. There are 174 questions in this chapter.
Chapter 4: Manage Reports: This chapter covers questions on exporting a report into various formats, managing and using the workbench, managing and using the repository. There are a total of 49 questions in this chapter.
Chapter 5: Create an Advanced Report: Questions in this chapter cover the following topics: creating a parameter, using dynamic cascading prompting, building and formatting a cross-tab report, using the running total expert, building report alerts and creating Top N reports. There are 118 questions in this chapter.
Chapter 6: Use Report Processing: Questions in this chapter cover the following topics: multiple pass processing, using the database expert, links and join types, setting up and configuring data sources, updating data sources, processing data on the server, validating a report, distributing personalized content and using an XML transform. There are 110 questions in this chapter.
Chapter 7: Use Subreports: This chapter covers questions on Subreports, covering linked and unlinked Subreports, On-Demand Subreports and the integration of shared variables within Subreports and linking ‘un-linkable’ data. There are 44 questions in this chapter.
Chapter 8: Create Complex Formulas and Custom Functions: This chapter covers questions on creating Custom Functions; areas covered include the utilization of Custom Functions via the Extractor and Editor, using evaluation time functions, using dynamic arrays, using print state functions, using loop control structures with arrays and creating Hyperlink reports. There are 65 questions in this chapter.