Add a Data Set

A data set fetches data from the Trimble Unity database tables to display data in a report. The DataSet panel is where you provide a command type and query string and choose other options for your data set. Common Values can also be used and are generic report fields that can be added to a report.

  1. Open the Report Designer.
  2. Click the Data tab.
  3. Click Add in the Data Sets section.

  1. Double-click the DefaultDataSet.

It appears under the Data Sets section.

  1. Click Edit Data Set.

  1. Edit the Name of the data set. Data set names cannot have spaces, but underscores or camel case could be used.
  2. Select Command Type. The default is Text.
  3. Enter a query to gather the desired fields from the desired database tables.

TIP: To add an entire table to a report, enter the following in the Query field: Select * from table.

These are the fields that are used to create reports.

If a custom data source was added to pull in GIS thumbnails or attachments, enter something similar in the Query field to connect to the files wanted:

  • GIS Thumbnails: thumbnail:<filename>.png
  • Attachments: attachment:<folder>/<filename>.png
  1. Click Validate.
  2. Click OK.

The fields appear in the Data Sets panel on the right side. Now these fields can be dragged and dropped in to a report.

If a data source hasn't been added, a connection to the Trimble Unity database is automatically added in the Data Sources section.