(Showing Draft Content)

Add a Custom Table

By adding a custom table, you can manually fill in an SQL query statement to generate a custom table. The custom table editor allows you to directly fill in the name of a stored procedure defined on the data source to call it. Note that the custom table option does not support cross-source operations, so you can only create custom tables based on a single data source.

  1. In the lower left corner of the Dataset Designer, click +Add Custom SQL Table. Add Custom Table
  2. In the Custom SQL Table dialog, enter the name of the newly added custom table, select the required data source, and select the query type as Text, then enter the SQL query command, and click OK.
  3. To use a stored procedure, in the Custom SQL Table dialog, select a data source, and select the query type as Stored Procedure.
  4. Select a stored procedure from the list and click OK.
    Custom SQL Table
  5. View the custom table under Custom Tables in the Data Sources area of the Dataset Designer.