Validation Report

Estimated reading time: 7 minutes


The Validation Report feature displays detailed information about Interject pull, save, and drill functions, data cell functions, and events. It is a tool to help report writers see how specific report formulas behave by interpreting the report formula inputs. When developing report templates, there are often many Interject report formulas in a single template. The Validation Report can help analyze the order of execution for the report formulas. This ensures that Interject events occur in the intended order. The Validation Report also shows report writers how to check if a formula is included in the Interject execution plan. Finally, the Validation Report tool displays to writers which parameters are being included in every report formula on the report template.

The Validation Report is located on the Advanced Menu of the Interject ribbon.

By selecting any of the validation options, you can view the code behind each action. Detail information is given for selected ranges, data portals, parameters, formatting codes, and more. This helps users learn as well as diagnose code problems.

Validation Report Options

The Validation Report can assist in analyzing Interject functions and events. For an overview on Interject events, see Event Functions.

Pull/Save Data Event

The Pull or Save Data Event will list detailed information for all Interject functions triggered by the Pull or Save Data event. Information shown includes:

  • Action : Lists the name of the function and its location in the report. (Functions will be ran in the order they appear.)
  • On Actions : The events that will trigger this function
  • Formula : The formula text of the function
  • Instruction Range : The range containing the instructions for the function
  • ErrorText : Any logged errors with the event
  • Function Instruction (Parameters) : Lists the parameters of the function in detail

Drill Event

The Drill Event command analyzes all ReportDrill functions within the sheet.

Clear Pull/Save Data Event

This command will list all functions that will be triggered on a Clear Pull or Clear Save event. It displays information similar to the Pull/Save Data Event.

Go Back Event

Displays functions triggered by the Go Back event (also called Return from Drill). (Note: This event is not currently functional.)

Data Cell Functions

Interject data cells focus on a single formula within the spreadsheet. The Data Cell Function option displays detailed information regarding data cells in the report so you can troubleshoot any issues.

This report contains 3 major sections:

  • Request XML
  • Current Formulas
  • Previously Loaded formulas

Request XML shows exactly what is sent to the data portal in XML form.

Current Formulas displays the current account balances within the data portal.

Previously Loaded Formulas will show the formulas loaded previously if any.

To display the cell references in the validation report, you can turn this option on in diagnostics by clicking "Toggle DataCell Audit Mode" and then Execute Selected Action:

This will show the cell references in the Data Cell Functions report:

Data Cell Last Change Report

This option shows the changes made from the last pull to the current one including the source formula for the change.

Cell Formula Review

Interject's Cell Formula Review is useful for displaying detailed information about a selected formula. For more information, see here.