The Value-Pair table is used to place data in the named shapes and cells.  To assign data to a name object (shape or cell), 



Column "Name" in the Value-Pair table holds the shape/cell name as defined on your template

Column "Value"  in the Value-Pair table holds the value to enter in the shape/cell.  Values can be regular strings or Excel formula.


phiReport implements non-Excel functions that can be used as Values in the Value-Pair table.


Curley braces are used to specify a DICT item.


PAGETOTAL         : Sum up data defined by {DICT} on the current page

RUNNINGTOTAL : Sum up data defined by {DICT} of all previous pages and the current page

DOCTOTAL         : Sum up data defined by {DICT} of all pages


In addition to the above phiReport functions, you can use any Excel compatible functions.


Value-Pair can also be returned from a BASIC program.


In your Pre-Query process program, add the COMMON below



Add data to USERDATA where USERDATA<1,X,1> = Name and USERDATA<1,X,2> = Value



To add a Line Feed to data, enter "<lf>" in the string to return.