Report Generation

Module 05 - Macros Development

• Why use macros

• How to Use Macros

• Recursion

• Labs

 

Module 06 – Working with Tables

• Tabular Export Background

• Accessing all Elements contained on a diagram

• Dynamic Row Creation

• Dynamic Column Creation

• Issues with tables

• Labs

 

Module 07 – Excel and Power Point

• How to export data into Excel

• How to export data into PowerPoint

• #forpage directive

• 2 labs

 

Module 08 – Built-in Templates

• Model Difference Report

• Oracle DDL, Code Engineerin

• Other Templates

 

Module 09 – Report Diagram

• Overview of Report diagrams

 

Module 10 - Report Patterns

• About Patterns

• Pattern: Filter-based Section

• Pattern: Tables to Select Report Content

• Pattern: ReoportWizard Selected Elements

• Pattern: Smart Package for Report Content Data

• Pattern: Report Model

• Pattern: Use Tables to Drive Reports

• Pattern: Preprocess complex data

• Pattern: Reading Writing JSON

• Anti-pattern: Monolithic Template

• Anti-pattern: Too Many Macros

• Anti-pattern: Hard-coded references

 

Module 11 – Template Development Process

• Documentation Useful for Template Development

• Template Development Process

• Reviewing the Target Template

• What is in the Model?

• What is the Model’s Metadata?

• Using VTL and model API to write the data

• Cameo Collaborator Custom Templates

• Template Development Best Practices

 

Module 12 - Intro to Collaborator

• Overview of Collaborator (note this is only an intro and not a tutorial