Move and modify existing fields


To	Do this
Move an existing field	Select and drag the field to a new location. By default, components snap to the displayed grid for easy alignment.
Adjust field size and alignment	Select a field and adjust its alignment and dimensions in the Position section in Page > Panel > Properties.

Add a new field

To add a new field, do the following:

Select an existing component.
Do one of the following:
- Copy and paste:
  1. Right-click the component and select Copy on the context menu.
  2. To paste the component, select the new location, right-click to display the context menu, and select Paste.
- On the Insert ribbon tab, select a component and drag it to the desired location.
- Select a component, press Ctrl, and drag a copy of the selected component to the desired location.
To move the component, click the new location.
To rename the component, select a component, and do either of the following:
- Double-click the component and enter a new name in the editor that appears.
- Right-click the component, select Design on the context menu, and enter a new name in the editor that appears.
Ensure that the Expression option is selected

View data fields

To display the data available to the report, do the following:

Select an existing component and right-click it.
Select Design on the context menu.

The editor opens.
Go to the Data Column tab.

The data available to the report is displayed.

Data field examples

It is important to understand the data relationships that are displayed. Relations are links to other tables defined by matching record data from one table to the other so that the correct records are associated to each other.

To retrieve data, not in the data source but in a relation created to other tables, you need to start in the data source assigned to the detail band in the report.

Example 1:

In this example, to retrieve the shape description that is not in the RequisitionItems data source, expand the RequisitionItems table. Then expand the associated data relation for Shapes2. Then you can select the description for the shape.

When you click Expression, the the above is displayed as {RequisitionItems.Shapes2.Description}

Example 2 for a Production Control project:

The report is based on the table ProductionControlItems.

It is possible to use the links for this table to link to other tables and pieces of other information.

The use of these navigation properties makes it possible to use a link from the ProductionControlItems table to get to the table ProductionControlJobs, and then access fields in that table that are not present in the ProductionControlItems table.

When you click Expression, the above is displayed as {ProductionControlItems.ProductionControlJobs.JobNumber}.

Combine text and data components

It is possible to combine label text and a data field. Braces identify the portion of the expression that is a formula or components of the data source. Items outside the braces are treated as pure text

In the above example the Expression would be the following:

Req#: {RequisitionItems.Requisitions.RequisitionNumber}

When the report is run, this shows the text ‘Req#:’ and then the requisition number.

Manage Stimulsoft report fields