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 :

ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256 

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.


EMPLOYEES Report  SQL:

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

enjoy...

click here to download an example.


Thanks for MojtabaNow , ArabOUG