| The quiz questions and activities are provided for your further understanding of the current hour's topics. Quiz | 1: | What is a special field? | | A1: | The special fields provided in the Field Explorer are a number of system variables that Crystal Reports provides for you to use within your reports (for example, page number, file author, data date, and so on). | | 2: | What is the difference between a formula and a SQL Expression? | | A2: | A SQL Expression must be written in the Structured Query Language of the Database you are using as a data source for the given report. SQL Expressions can increase the efficiency of your reports by passing the entire expression to the database to process. Formulas provide increased flexibility through a powerful library of Crystal and VB syntax, but they slow report processing performance when they must be executed on the server that holds Crystal Reports. |
Activities Now that you have started playing with the Crystal Reports Designer in full Designer mode, try connecting to one of your own local databases and creating a simple listing report with different types of groupings. |