Use these fields and options to execute a stored procedure on the database. For the auto numbering feature, the stored procedure must return one output parameter.
Field | Description |
Stored Procedure
|
Enter the name of the stored procedure. The arguments for the stored procedure display in the Arguments grid.
|
Arguments Grid
The list of arguments populates automatically, based on the stored procedure selected.
Field | Description |
Arguments Drop-down
|
Click the drop-down arrow on a grid header to complete any of the following actions:
- To print grid data, click
Print. On the Print Preview form, click
to send the grid data to your default printer.
- To export grid data to an Excel spreadsheet, click
Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally.
- To turn on grouping for a grid, click
Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display.
Not all options are available on all grids.
|
Name
|
This field displays the name of the argument.
|
Value
|
This field displays the SQL expression, used to determine the value of the argument at run time. Click the ellipsis icon in this field to display the SQL Expression Builder so that you can define the values.
|