Specifications

CHAPTER 5 Defining Reports
Users Guide 183
• To define the result set description manually, select the Manual Result
Set check box and click Next.
In the Define Stored Procedure Result Set dialog box:
• Enter the name and type of the first column in the result set.
• To add additional columns, click Add.
Your preference is saved
InfoMaker records your preference for building result set descriptions for
stored procedure reports in the variable Stored_Procedure_Build in the
InfoMaker initialization file. If this variable is set to 1, InfoMaker will
automatically build the result set; if the variable is set to 0, you are
prompted to define the result set description.
4 Continue in the Report wizard as needed for the presentation style you are
using.
When you have finished interacting with the wizard, you go to the Report
painter with the columns specified in the result set placed in the report.
For information about defining retrieval arguments for reports, see
Chapter 6, “Enhancing Reports.”
Editing a result set
description
After you create a result set that uses a stored procedure, you can edit the result
set description from the Report painter.
❖ To edit the result set description:
1 Select Design>Data Source from the menu bar.
This displays the Column Specification view if it is not already displayed.
2 Select Stored Procedure from the Column Specification view’s pop-up
menu.
The Modify Stored Procedure dialog box displays.
3 Edit the Execute statement, select another stored procedure, or add
arguments.
The syntax is:
execute sp_procname;num arg1 = :arg1, arg2 = :arg2..., argn =:argn
where sp_procname is the name of the stored procedure, num is the stored
procedure group suffix, and arg1, arg2, and argn are the stored
procedure’s arguments.