Specifications

Storing data in a report using the Data view
230 InfoMaker
Modifying the result set
If the data source is External or Stored Procedure, you can modify the result set
description.
❖ To modify a result set:
1 If the Column Specification view is not open, select View>Column
Specifications from the menu bar.
2 Review the specifications and make any necessary changes.
If the data source is a
stored procedure
If you are modifying the result set for a report whose data source is a stored
procedure, the pop-up menu for the Column Specification view contains the
menu item Stored Procedure.
Select Stored Procedure from the Column Specification view’s pop-up menu
to edit the Execute statement, select another stored procedure, or add retrieval
arguments. For more information about editing the Execute statement, see
“Using Stored Procedure” on page 182.
Storing data in a report using the Data view
Usually you retrieve data into a report from the database, because the data is
changeable and you want the latest information. However, sometimes the data
you display in a report never changes (as in a list of states or provinces), and
sometimes you need a snapshot of the data at a certain point in time. In these
situations, you can store the data in the report itself. You do not need to go out
to the database or other data source to display the data.
The most common reason to store data in a report is for use as a drop-down
DataWindow where the data is not coming from a database. For example, you
might want to display a list of postal codes for entering values in a State or
Province column in a form. You can store those codes in a report and use the
DropDownDataWindow edit style for the column.
For more information about using the DropDownDataWindow edit style, see
Chapter 8, “Displaying and Validating Data.”