Drill Down/ Call Report From a Report.

To call a report from a report follow the below mentioned steps.

1) Select event on which drill down report will execute i.e. button, trigger etc.
2) Select SRW package i.e. Srw.Run _Report
Srw.Run_Report('Report= Client_Dtl Batch=NO Client_Id=' :PF_CLIENT_ID );
Where Client_Dtl is the child report , :PF_CLIENT_ID is the parameter for child report.

Note: Be careful about the apace because here it works as a separator.

Icon Configuration In Oracle 9i/10gds Forms

When running an Oracle Forms application the icon files used must be in a web enabled format such as JPG or GIF (GIF is the default format). This is unlike older versions of forms running in client-server mode when the file format is .ico

1] Gather all the icon files in a directory.For this copy all the icons files (gif or jpg) to a folder e.g c:\icons or /tmp/icons folder 2] Create the jar including the icons. Change directory to the target icons folder: cd c:\icons or cd /tmp/icons

2a) Set jdk_Home
E.g. set Jdk_Home=E:\10Ghome\Jdk
2b) Set Path
E.g. Set Path=E:\10Ghome \jdk\bin;%PATH%2c) Jar the icon files issue: jar -cvf icons.jar * 3] Place the jar in \forms\java 4] Edit the \forms\server\formsweb.cfg 4a) Tell the applet to load the jar: archive_jini=xxall_jinit.jar,icons.jar 4b) Indicate the images are relative to forms/java virtual directory: imageBase=codeBase (Be careful about case as java is case sensitive)