Create a data grid object

The data grid object shows the following data in the form of a table:
  • Database information stored in a SQL Server, including historical alarm, data log, user-defined database, and so forth.
  • Data log information stored in file sets or DataLogPro.
  • Historical information stored in the historian server (Historian SE, Historian ME, or PI Server).
By retrieving data from a SQL Server database's table or view, a data log, or a historian server, the data grid shows the fields of a data source as columns. Each row represents a record in the data source.
At design time and runtime, you can configure what data will be shown on the object and how the object will look by:
  • Selecting table or view of a SQL Server database, a data log, or a historian server.
  • Setting up filter and sort for the data to be shown.
  • Customizing the appearance of the data grid.
Prerequisites
  • To retrieve and display historical data stored in a SQL Server database, create a database connection in the FactoryTalk system.
To create a data grid object
  1. In
    FactoryTalk View Studio
    , in the Graphic editor, open a display.
  2. On the toolbox, select
    Advanced
     >
    Data Grid
    .
  3. On the display, drag the mouse to draw the approximate size that the data grid object is to be.
  4. In the
    Data Grid Properties
     dialog box, on the
    General
     tab, select the options to show at runtime.
  5. Select
    Setup
    .
    1. On the
      Data Binding
       tab, configure what data will be displayed on the data grid object.
    2. On the
      Appearance
       tab, configure how the data grid object will look.
    3. Select
      OK
      .
  6. Select
    OK
    .
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal