Chapter 3. Advanced Topics

Table of Contents

1. MetaSQL
1.1. MetaSQL in Practice
1.2. MetaSQL Syntax
1.2.1. Control Statements
1.2.2. Functions
2. MetaSQL Editor
2.1. Connecting to a Database
2.2. Entering a Query
2.3. Defining Parameters and Values
2.4. Parsing and Executing a Query
2.5. Resulting Standard SQL
3. Report Renderer
3.1. Connecting to a Database
3.2. Ad Hoc Reports
3.3. Loading Report Definitions
3.4. Adding OpenRPT Renderer Runtime Parameters
3.4.1. Define Parameter
3.4.2. Set Parameter Value
3.4.3. Changing Parameter Values
3.4.4. Deleting a Parameter
3.4.5. Generating the Ad Hoc Report
4. Watermarks and Background Images
4.1. Background Images
4.1.1. General
4.1.2. Layout
4.1.3. Static Image
4.2. Watermarks
5. Bar Coding
6. Graphing
6.1. Graphical Report Output
6.2. Graphical Report Definition
6.2.1. Query Source
6.2.2. Color Definitions
6.3. Defining the Graphing Object
6.3.1. Graph Editor General Tab
6.3.2. Graph Editor Data Axis Tab
6.3.3. Graph Editor Value Tab
6.3.4. Graph Editor Series Tab

In this chapter we will cover a range of advanced topics. We touched on some of these topics in earlier chapters. Others will be presented here for the first time. Subjects covered in this chapter include the following: