Insert Column Values

Use the Insert Column Values dialog box to add column values to a URL. The left pane of the dialog box lists all of the tables, columns, and expressions defined in your query.

To add a column to a URL, select the desired column from the left pane. To select a column, you can:

Drag a column into the Edit field (the right pane). As you drag the column, the cursor position in the Edit field shows you where the column name will be inserted.
Double-click a column to enter it into the Edit field at the current cursor position.
Select the column and click Insert.

For example, assume you had a report that contained sales information by region.

Central America	4,000,000
South America	7,500,000
North America	6,000,000
Europe 3	,450,000

Using the Insert Column Values dialog box, you could build a URL that hyperlinks each region to a more detailed report on that region,

http://sales.acme.com/regional_sales_report?region_id=<##REGIONS.REGION_ID>

or to an e-mail address for the sales manager for that region.

mailto:<##EMPLOYEES.EMAIL_ADDRESS>