A script-enabled browser is required for this page to function properly.

Passing Record Groups to Reports or Graphics

You can pass a record group to Reports or Graphics as a DATA parameter. This DATA parameter is a special type of parameter that gives a signal to the integration code to substitute the contents of the record group whose name you give for the results of the query named by the query name you indicate.

Example

First, in Reports, create a report with a query:

Query Name: FOOBAR_QUERY
Query: SELECT DEPTNO, DNAME FROM DEPT

Next, in Oracle Forms, you create a record group in your favorite way such that it has two columns, one NUMBER and one CHAR. Then you populate that record group (still on the forms side). Say the record group is called PETE, and has two columns A and B:

DECLARE
f RecordGroup;
g GroupColumn; 
BEGIN
f := CREATE_GROUP('Pete'); 
g := ADD_GROUP_COLUMN( f , 'A', NUMBER_COLUMN); 
g := ADD_GROUP_COLUMN( f , 'B', CHAR_COLUMN, 20); 
/*
** Then populate the group in your favorite way
*/
END;

When you set up the parameter List that will be passed from forms to the other tool, you create a parameter named FOOBAR_QUERY and give it the value of 'PETE'. Since it is a DATA parameter, this pairing of FOOBAR_QUERY to PETE tells the integration code what to do when it starts up the other tool. Instead of running the select statement that defines FOOBAR_QUERY in Reports, the values from the PETE record group will be substituted as if they were the result.