What’s In A Macro File?

• One or more Variable Definition Sections:

  • Used to define and manipulate macro variables

• One or more SQL Command Sections:

  • Contains one SQL statement
  • May contain a user-defined report format for the SQL statement (optional)

• One HTML Input Section:

  • Used to get input variable values from user

• One HTML Report Section:

  • Used to generate reports from SQL query results

Previous slide

Next slide

Back to first slide

View graphic version