Home » Developer & Programmer » Forms » Example of Passing record group to Report Builder 6i
Example of Passing record group to Report Builder 6i [message #306195] Thu, 13 March 2008 04:36 Go to next message
hasnainlakhani
Messages: 24
Registered: January 2007
Junior Member
Could any one send me a file as an example which passes record group to Report Builder 6i

Re: Example of Passing record group to Report Builder 6i [message #306424 is a reply to message #306195] Fri, 14 March 2008 02:40 Go to previous messageGo to next message
misragopal
Messages: 125
Registered: June 2005
Location: New Delhi, india
Senior Member

Hi,
We need to create a record group(either query or static) in forms and a query in reports. We can pass this record group as 'DATA_PARAMETER' to reports.

# create a report with no data query. like
select tname, tabtype, clusterid from tab 
where 1=2;

# Rename query by REP_RG_TAB.

#IN forms, Create a Query record group, name it as 'FRM_RG_TAB'.
place BELOW code on trigger.
DECLARE
  plist ParamList; 
  errcode NUMBER;
BEGIN 

  plist := Get_Parameter_List('DATA_TMP'); 

  IF NOT Id_Null(plist) THEN 
    Destroy_Parameter_List( plist ); 
  END IF; 

  plist := Create_Parameter_List('DATA_TMP'); 

  errcode := POPULATE_GROUP_WITH_QUERY(
                                      'FRM_RG_TAB', 
                                      'SELECT  TNAME, TABTYPE, CLUSTERID FROM TAB'); 

   Add_Parameter(plist,
                 'REP_RG_TAB',
                 DATA_PARAMETER,
                 'FRM_RG_TAB'); 
  
   Add_Parameter(plist, 
                'PARAMFORM', 
                TEXT_PARAMETER, 
                'NO');

  Run_Product(REPORTS, 
              'empreport.REP', 
              SYNCHRONOUS, 
              RUNTIME, 
              FILESYSTEM, 
              plist, 
              NULL); 
END; 


Gopal
Re: Example of Passing record group to Report Builder 6i [message #307456 is a reply to message #306424] Tue, 18 March 2008 23:12 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
You may wish to read http://www.orafaq.com/forum/t/98889/67467/
and http://www.orafaq.com/forum/m/299700/67467/#msg_299700 so that you are aware that this facility may not be compatible with Forms 10g.

David
Previous Topic: Dynamically populate 2nd drop down list based on the 1st list value
Next Topic: How to label a button from the next line in forms 6i..
Goto Forum:
  


Current Time: Sun Feb 09 22:06:33 CST 2025