- In Edit Data Set, choose Query.
You access Edit Data Set by creating a new data set or by right-clicking an existing data set and choosing Edit from the context menu.
Edit Data Set--Query appears.
- In Available Items, all tables in the data source appear by default. You can use the filter options to specify the tables or views to display.
- If you want to see only views in the JDBC data source, select View in Type and choose Apply Filter. If you want to see all tables and views, select All and choose Apply Filter.
- If the data source has a large number of tables or views, you can limit the number of tables or view names retrieved by typing one or more letters in the Filter field and choosing Apply Filter. Available items displays the tables or views that have names beginning with the same letter or letters you typed. You also can use SQL filter characters for the database you are using. For example, on some databases, an underscore (_) matches any single character and the percent sign (%) matches any sequence of characters.
- If the database supports schemas, a Schema field is available. Type in a schema name to display tables and views from that schema.
- To view the columns in a table or view, select the plus sign (+) beside a table or view name.
- In the text area, type a SQL statement that specifies the data to retrieve from the JDBC data source. You can also drag tables, views, and columns from Available Items to the text area to insert their names into the SQL statement at the insertion point.
If you want to support users specifying values for conditions and other parts of the query, use parameters in the SQL query. For more information about creating parameters to use in the query, see You can add sorting to a query by using a ORDER BY clause in the SQL SELECT statement. For information about ORDER BY clauses and SQL SELECT statements, see the database documentation or a SQL reference guide.
- Choose OK.
BIRT Report Designer saves the data set. The data set appears in Data Explorer.