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...
Update : using the following code to get more info :
