Home » Developer & Programmer » Forms » how to pass Record grps to reports????
how to pass Record grps to reports???? [message #79840] Wed, 17 July 2002 21:19 Go to next message
JERALD
Messages: 3
Registered: June 2002
Junior Member
hi all
I'd like to pass a recordgroup from form to report using data parameter..pls help me out regarding this...
thanks in advance
jerald
Re: how to pass Record grps to reports???? [message #79844 is a reply to message #79840] Thu, 18 July 2002 01:05 Go to previous message
subbu
Messages: 27
Registered: July 2002
Junior Member
Hi ,
To pass a record grp to a report first u have to create a report containing all the columns that u r passing though the record group.
Then in the form call the report using run_product.
Before that, when u add the parameter to the parameter list use DATAPARMETER instead of TEXTPARAMETER.like this
add_parameter('parameter_id','XXXX',DATA_PARAMETER,'YYYY');

Here "XXXX" -- should be same as the name of the query in the report builder.
and "YYYY" --- should be the name of ur record group.
Previous Topic: how to prevent duplicate entries in multi record block
Next Topic: Oracle Forms - Implementing set scan off in pl/sql
Goto Forum:
  


Current Time: Thu Mar 28 08:11:26 CDT 2024