Flow of Template Generation

The purpose of this topic is to help the systems developer be aware of the order in which things are done. The following description outlines everything that is done by the system when opening a template.

The following occurs when opening the template (REPORT / FORM):

• The workbook/template is opened from the database.
• Valid drills are examined by executing app.p_user_drilldown_list.
• Dynamic images are loaded to the book, if they exist.

 SELECT * from app.client_settings WHERE client_setting_id = '118' AND client_id = @cid

 SELECT * from app.settings WHERE app_setting_id = '118'

• Order values are written to PANE.
• The procedure dis.p_get_datastore_dimensions is executed for $DIM replacement in the template.
• The form is validated to ensure accuracy.
• If an error sheet exists, it is deleted.
• VIEWTAGS from PARAM are fetched and saved to memory.
• #pane and #template_values are created in the database with order values, etc.
• Variables in the template are exchanged. The variables are:

  •  $LONGDATE

  • $LONGTIME

  • $SHORTDATE

  • $SHORTTIME

  • $CLIENTDESCR

  • $USERNAME

  • $CLIENT

  • $USER

• Foreground and interior color is set for entry and no-entry input cells.
• Break sheets are generated, either from standard or ADDSHET_PROC procedure.
• If REPORT and ADDSHEET_TOTAL exists, a Total sheet is created.
• Spreadkeys are evaluated from database and form.
• Check original Freeze panes and adjust those for each sheet.
• Check comment in cell A1 and check #FREEZE.
• Check ENABLE_UPDATE and DISABLE_SAVE and save setting to memory.
• Get script from database, if it exists.
• Read order values from PANE and save them to memory.
• AUTO_UPDATE parameter is checked and saved to memory.
• Execute GETTABLE.
• Check SUBTOTAL rows and save them to memory.
• Create #plandata (if needed).
• Create #findata (if needed).
• Run Before Document Creation script.
• Execute Dynamic Columns.
• Execute After Dynamic Columns script.
• Execute Row Grouping.
• Execute ADDINFO.
• SQL is created and executed to get values to the each sheet

The following occurs once a Sheet is complete:

• Run After Document Creation script.
• Spread values are updated on the sheet.
• Subtotals are executed.
• Apply VIEWTAGS.
• Check for ENTRY and NOENTRY, and lock/unlock cells and colorize them correctly.
• Run After Workbook Completed script.