1. Loading Files and Database Data
- What is a qvd file? Optimized load
- Using ODBC and OLEDB
- Script Checking and Debugging
- Script control flow (conditional, loops)
2. Associating Data from Several Tables
- Associations
- Loading and associating a second table
- Renaming fields
- Qualify / Unqualify
- Mappings
- Save table to file
- Resident data source
3. Concatenating Tables
- Opening the document
- Automatic concatenation
- Forced concatenation
4. The Data Model
- Using the Table Viewer: table and field information available
- Labeling tables in the script
5. Hierarchical Data & List Box
- Loading hierarchical data
- Setting Listbox presentation as hierarchical
6. Dollar sign expansion revisited
- Using Expressions
- Dollar sign Expansion
- Using Variables to store expressions
7. Load Inline
- Adding a record with load inline
- Adding a table with load inline
8. Loading Additional Files
- Loading a tab separated file without labels
- Loading a file via OLE DB
9. Linking External Information to a Document
- Looking at an info table
- Loading the info table
- Viewing the linked information
- Embedding external info
- Displaying info in a text object
10. Advanced Object parametrization
- Field groups
- Cyclic display of expressions
- Showing data as image
11. Advanced calculations: Set Expressions
- All records Data Set
- Selected records Data Set
- Filters in set expression
- Set operations
12. Alternate States
- Enabling alternate sets
- Setting alternate states
- Using alternate states in objects and expressions
13. Number Formats
- Handling of numeric data
- Interpretation of numeric data
- Formatting of data
- Type conversion
14. Actions
- Simple Actions
- Assigning a value to a variable
- Writing and Executing a Macro – QV API Object Model
15. Layout Themes
- Using an existing theme
- Theme structure
- Creating a theme
- Applying a theme
16. Security
- Sections in the Script
- Access levels
- Security fields
- Loading security tables
- Using the Security pages
- Field restriction and values restriction
- Opening a document with access restriction: data reduction
- Sheet security
17. More about Associations
- Creating a system sheet
- Using the system sheet
- Creating a system table
- Showing frequency in key fields