Previous TopicNext Topic


How to specify a stored procedure for a JDBC data set

  1. Choose Data Explorer.
  2. Right-click Data Sets and choose New Data Set from the context menu.
  3. New Data Set appears.

  4. Specify the properties of the data set.
    1. In Data Set Name, specify a name for the data set.
    2. The data set name must be unique in the report design.
    3. In Data Source, use the drop-down list to choose a data source to use for this data set.
    4. In Data Set Type, select SQL Stored Procedure Query.
  5. Choose Finish.
  6. Edit Data Set appears.
  7. In Edit Data Set, choose Query.
  8. Edit Data Set--Query appears.

  9. In Available Items, navigate to the stored procedure. For more information about using the filtering features to display only specific schemas and stored procedures, see
  10. Select the stored procedure and drag it to the text area. The stored procedure name appears at the insertion point. In the text area, type the required information to execute the stored procedure. For example, you should any arguments passed to the stored procedure.
    • To type the stored procedure, enclose the call statement in left and right curly braces, for example {call sp_name(`argument')}.
    • You can also type the stored procedure without the curly braces, in which case BIRT treats the statement as a regular RDBMS call and so execution is dependent upon the RDBMS of your data source, e.g. for Oracle, you could type exec sp_sales(`CUSTOMERS');
    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.
  11. Choose OK.
  12. BIRT Report Designer saves the data set. The data set appears in Data Explorer.

(c) Copyright Actuate Corporation 2006

Previous TopicNext Topic