Configure and Call Report from a Form ORACLE 10g

Assalamu Alikom ,

After many attempts to run  a report from the current form in ORACLE 10g.

I found this is the easiest method.

Update #1 :
To display Arabic Characters without bugs  of Reports , follow these steps :
1# Go to Start Menu then type REGEDIT press Enter
2# Search For Reports_Path then add C:\Windows\Fonts (the Windows Font Folder)
note that there may be more than REPORTS_PATH in Registry , so edit all found.

3# Then Go to c:\DevSuiteHome_1\tools\common\  and replace file uifont.ali  with this one (download from here...)
Your are done...

Update #2 :Also to make The Default Direction right to Left :
1#Search  for NLS_LANG  in Registry and replace all values with :

Update #3 :Also to avoid errors while displaying Arabic chracters and Errors like TIMES.TTF
you must add path like following:
C:\oracle\jdk\jre\bin\classic;C:\oracle\jdk\jre\bin;C:\oracle\jdk\jre\bin\client;C:\oracle\jlib;C:\oracle\bin;C:\oracle\jre\1.4.2\bin\client;C:\oracle\jre\1.4.2\bin;C:\oracle\product\10.2.0\db_1\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files\Microsoft SQL Server\120\Tools\Binn\

Update #4 :Create Report Server :
Open START menu then open RUN then write down :
rwserver server=empsrv

First we assume we have EMPLOYEES Report and  DEPARTMENTS Form.

Select last_name , salary , department_id
From employees
Where department_id=:p_dept

--where :p_dept is  the user parameter in reports.

DEPARTMENTS Form SQL select * from employees

we create a button   and mark  Mouse Navigate :NO
and  when_button_pressed trigger:

web.show_document('http://nextpast-pc:8889/reports/rwservlet?server=empsrv&destype=cache&desformat=pdf&report=E:\Faramawy\cscourse\Areej_Script\Reports\emps.jsp&userid=hr/hr@orcl& p_dept ='||:department_id);

--where p_dept  is case-sensitive  as it was written in Reports.
--and  :department_id is the name of department_id column shown on Form.

#Before Running form you must run Reports Server as following :
Start--Run-- rwserver server=empsrv

-- where empsrv  is the name of Reports Server


No comments: