Tag Query Columns for the Report Studio

All tables start with a single column. Click the [+] bar to the right to add extra columns.
Note that a tag query that includes multiple tags or calculations will generate as many columns as needed to display the result of the query.

Tag queries are typically placed in column B of a table. Note that summary titles are always placed in the first column of a table and therefore data that you intend to summarize should not also be in that column. Recommended practice is place a Time-type data set in Column A.

If your query involves more than one tag or more than one calculation, additional columns will be created as required when the report runs, to a limit of 30 columns. You do not need to create a separate column for every tag and every calculation.
Very few reports will ever need a column C.

Whether configuring time or a tag query, start by clicking in the title row as shown to open the Data Cell Properties panel. (Clicking the A or B above the row does nothing.)

With the Data Cell Properties panel, you can do the following for Tag Query data sets:

Delete the column

Click the trash can icon in the header of the Data Cell Properties panel:

Data Set selection

Every time column definition and every tag query is stored as a named "Data Set". You are advised to give each a descriptive name because it is likely that you will eventually have many.

No predefined data sets exist for tag queries. You must create one using the tags in your application.

• Click the pencil button to allow editing of the following properties.
• Click the plus button [+] to create a new data set with a name of your choosing.
• Click the copy button to clone a data set.

Type

Must be set to "Tag Query" for this column to include tag data from your application. This includes the Raw Timestamp column.

Context

Context can be used in two ways:

• As a filter, limiting tag selection to those below a parent tag such as a station.
• As a parameter, allowing the same report to be run for multiple contexts or stations.

To use Context as a filter, select a parent tag. The Tag Selector will show only child tags of that parent.

To use Context as a parameter, you must first create a parameter. Refer to Parameterized Reports. Note that a value must be assigned to the parameter for use in the Report Studio before you can continue with further steps. Proceed to tag selection as usual. When operators run the report, they will be prompted to select a station or other parent tag to use for that instance of the report. Use Report Tags to predefine a choice for the parameter.

Tag Selector

Opens the Tag Selector Dialog, where you can select the tags to include in the report. If a Context was set, only child tags of that parent will be shown. The order of the tags in the Tag Selector dialog will affect the order of the columns in the report.

Data Columns

Add as many data columns as needed by clicking the <<Click to Add>> tool at the bottom of the list. There must always be at least one data column for every data set. Values in a report can be averages, snapshots, minimums, etc.

If the data column displays a time value (e.g. Time of Minimum, Raw Timestamp, ...) you can open the Make Parameterized Phrase dialog to display time and date in the format of your choice. This is usually required for Raw Timestamps, which are measured to the millisecond.

If reporting on Raw Timestamp and Raw Data values for more than one tag, note that the column for each tag is generated independently. Timestamps are unlikely to match across any row.

To remove the default function, add a second data column using the function you want, then delete the first. Arrows to the side of the Data Columns list allow you to change the order of the functions.

Group Data Columns By Tag

Given a Data Set with multiple tags and multiple data columns, the default is to group the output by tag. You could choose instead to group by the data column function. For example, a set of columns showing all of the averages, then a set of columns showing all of the minimums, etc.

For complex groupings, you might use multiple tag-query columns. ( C, D, etc...)

Title

Sets the title for each column. Because columns are generated automatically according to your tag query, it is typical to use parameters to define titles dynamically.

Select from the drop-down list of predefined titles or click the provided button to open the Make Parameterized Phrase dialog.

Summary Suppression

Typically used when both of the following conditions are true:

• You have created one or more summary rows
• And your report includes two or more data sets.

If either of those conditions is not true, there is no need to suppress summary information.

An example of where you might use this is a pump report that includes a data column for flow characteristics, and a column for pump run time. The first data set might be summarized with a Range. The second might be summarized with a total. You would suppress the Range summary for the pump starts columns and suppress the total summary for the flow characteristics columns.

The exercise will continue.