Creating a SQL Table Paragraph

Use this report component to create tables from simple SQL queries.

A SQL Table paragraph consists of a SQL query (defined on the Query tab) which is used to extract data from the database, and a report table (defined on the Table tab) which is used to present the data. The process for creating a SQL table paragraph is as follows:

To create and bind a SQL query:

1. Click New Paragraph to open the Add Paragraph dialog and choose SQL Table. The New SQL Table screen opens
2. On the General tab, enter a name for the paragraph. This will identify the paragraph in the report structure pane.
3. On the Query tab, write your SQL query.
4. Click Apply to validate and save the query
5. Click the Bind Data button to bind selected columns to columns on the table tab. This extracts selected column names or aliases from your query, and binds them to report table columns.

   Note

   If your data columns were not bound check the following:

   • You clicked Apply to save the query before you clicked Bind Data.
   • Your query is valid SQL syntax for the database you are using. You will receive an error message if you attempt to bind data from an invalid or unsaved query.
6. On the Table tab, make any changes you need to your report table. See Working with Report Tables and Columns for more information.
7. Click Save to save your changes.

Using parameters in a SQL query

You can substitute parameter values in SQL queries by enclosing the parameter name in a pair of carets. For example ^MyParameter^. For object, attribute type and tag parameters, the value substituted is the integer primary key.