To manually map an object property to a column or parameter value, select a variable type and a variable on the Variable bar and then click a property name in the Object Inspector.
You can also type the column or parameter name preceded by an equals sign (=):
=column_name
The following table shows situations where you might want to map a column from an SQL query to a property value.
Mapping task | Procedure |
---|---|
Change the data symbol used in a 2-D layout | 1. Delete the default data symbol. 2. Insert the new symbol. 3. Map the appropriate column to the Value property of the inserted data symbol. |
Label each data point in a 2-D layout | 1. Insert a Text object into the data template. 2. Map the column you want to be displayed in the label (for example, customer_name) to the Value property of the Text object. |
Map an object property when the Layout wizard does not provide this step. | 1. Open the data template of the layout. 2. Insert the object you want to be mapped to the column value. For example, insert a Text object if you want to display the column value as text. 3. Map the column to the Value property of the inserted objects. |
Modify the mapping after you change the query for a data template. For example, you might want to duplicate a layout and data template but display different data. | 1. Open the data template. 2. Right-click and click Change query and then select a new query in the dialog box. 3. In the revised data template, map the column you want to the Value property of the appropriate object in the data template. |