Use "Binding" tags in a query at run time

In Excel, a group of cells (a range) can be referenced by single name. A report that you create using the AVEVA Historian Client Workbook can contain the named ranges "AFTagBinding," "AFStartBinding," and "AFEndBinding."

The AFTagBinding range is a placeholder for one or more tags in the query. This range can accept different sets of tags assigned to it, allowing you to programmatically control the tags used for the query without altering the actual query string. This is very useful if you are publishing reports on demand; you can "bind" a set of tags or times to the report at runtime.

The AFStartBinding and AFEndBinding ranges work the same as the AFTagBinding range, except that they are used as placeholders for the date and time specification.

The binding values can be used in the following ways:

• Publish the workbook report as a dynamic report to the AVEVA Information Server. The user can select the report and then select a group of tags. When the report is run, the binding ranges are updated with the user-selected information, the queries are executed, and the finished report appears in the browser.

• Programmatically update the ranges using the RunReport method of either the AVEVA Historian Client Workbook add-in or the WorkbookRunner object.