Configure Time Columns
See Also
The Report Studio is still under development and has not officially been released. Be warned that code may change such that reports you create with this pre-release trial version might need to be updated in order to continue working after your next VTScada update.
Until the official release, documentation for the Report Studio will open in response to the F1 key but will not be shown in the menu system. To view a table of contents for the complete chapter, navigate to The Report Studio
All tables start with a single column. Click the [+] bar to the right to add more.
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.
Time values (where the Data Set type is "Time") are typically displayed in column A of a table. This recommended because summary labels (if summaries are used) are always placed in the first column and therefore work best below time values, which are never summarized. You are free to choose any column for time and might choose to have several time columns if the format differs or if you want to repeat the timestamp in a report with many columns.
The Time data cell type is recommended for reports with aggregated data. A separate Time column may not be needed if creating an Alarm & Events report.
Whether configuring time or a query, start by clicking in the title row as shown following to open the Data Cell Properties panel.
Select column A to define a time-based Data Set
To create a Time Data Set you have two options:
- With the correct column highlighted, click the [+] that appears in the new Data Cell Properties pane.
- Click the [+] on the bottom-left below the Data Set Manager.
Either of these options will present you with a New Data Set dialog. Choose a name and select "Time" as the type.
Actions for a Time Data Set type:
Delete the column
Click the trash can icon in the header of the Data Cell Properties panel. This deletes the column from the table but does not delete the Data Set definition. (You can delete the Data Set from the Data Set Manager).
Select or create a Data Set
Every single custom column configuration can be saved as a Data Set. You can swap the Data Set featured in a column with a different one, edit its configuration, copy to make small changes and save as a brand new Data Set and even completely delete Data Sets (from the Data Set Manager).
You will likely accrue many of them in your droplist. It would be easy to lose track so it's a best practice to give them each a descriptive name.
Click the [+] to create a new Data Set or use the droplist to change the Data Set associated with whichever column you've selected.
Define a Header
Text displayed at the top of the column. Defaults to "Date". Replace with any other wording that is appropriate.
Select a Date Format and Time Format
The format for time and date can be edited by making a parameterized phrase.
Click on button to the right of the field to open the Parameterized Phrases dialog. Multiple formats are available for selection, or you can enter a format of your own using the available Date Formatting Strings and Time Formatting Strings.
