Field List

The Field List displays all Report Parameters and Data Sources with their configured queries.

Data Sources

When a data source is selected, you will see the following options:

• Edit Master-Detail Relations : Opens the Master-Detail Relation Editor. The Master-Detail Relation Editor allows you to define a relationship between two queries that share a field.
• Add Calculated Field : Adds a calculated field to the query. A calculated field has a value that is calculated by an expression. The calculated field appears in the list of fields under the table.
• Add Query : Launches the Data Source Wizard. For more information on configuring a query see Configure a Query.
• Remove Data Source : Deletes the data source from the report.

Edit a data source name

You can edit the data source name through the Properties panel.

Edit the name of a data source using the Properties panel

1. Open the Properties panel .
2. Expand the and select the data source name.
3. Edit the name of the data source.

See also...

Configure a Data Source

Queries

When a Query within a data source is selected, you will see the following options:

• Edit Query : Launches the Data Source Wizard. For more information on configuring a query see Configure a Query

  To modify the name of a query, in the Data Source Wizard, change the name of the query in the Query Name property and then click Finish.

• Add Calculated Field : Adds a calculated field to the query. A calculated field has a value that is calculated by an expression. The calculated field appears in the list of fields under the table.
• Remove Query : Deletes the query from the report.

Parameters

Clicking the Add Parameter button opens the Add Parameter dialog. In the dialog you will see the following properties:

• Name: The name assigned to the parameter.
• Description: A description of the parameter.
• Type: The data type expected as input. If using an OBJECTID field as your input, this should be set to Number (32 bit integer).
• Visible: Determines whether the parameter is visible in the client application running the report.
• Multi-Value: When enabled, this property allows multiple values to be passed to the parameter.
• Allow Null: Determines whether null values can be passed as an input.
• Expression: An optional expression used to set a Value.
• Value: Provides a pre-defined value or values to be used when running a report.