ORACLE : How to call a report in Forms 10g ?

February 2nd, 2013, posted in Oracle
Share

Lets talk about version 10g Developer Suite.

In development environment you need to run report server manually but at Application Server it’s not needed.

How can we run report server manually ?
Just go to start menu >> run and type
rwserver SERVER=myserver
 
Where myserver is the server name.
Now reports server runs.
Make changes(Report Name) on following code and  try this in a Button trigger :
DECLARE
v_repid REPORT_OBJECT;
v_rep VARCHAR2(100);
v_rep_status VARCHAR2(100);
v_param VARCHAR2(200) := NULL;
v_valor VARCHAR2(200);
v_url VARCHAR2(2000);
v_repserver varchar2(20) := 'myserver';
v_report varchar2(100) := 'D:REPORT_NAME.REP';
v_PARAMETRO varchar2(100) := '';
BEGIN
v_repid := FIND_REPORT_OBJECT('MYREPORT'); -- report is an element from object navigator report
SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_FILENAME, v_report);
SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_EXECUTION_MODE, BATCH);
SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_COMM_MODE, SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_DESTYPE, cache);
SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_DESFORMAT, 'pdf' );
SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_DESNAME, v_report);
SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_SERVER, v_repserver);
SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_OTHER, 'paramform=no '||v_PARAMETRO);
v_rep := RUN_REPORT_OBJECT(v_repid);
v_rep_status := REPORT_OBJECT_STATUS(v_rep);
WHILE v_rep_status IN ('RUNNING','OPENING_REPORT','ENQUEUED') LOOP
v_rep_status := REPORT_OBJECT_STATUS(v_rep);
END LOOP;
IF v_rep_status = 'FINISHED' THEN
message(v_rep);
message(v_rep);
WEB.SHOW_DOCUMENT(v_url||'/reports/rwservlet/getjobid'||
SUBSTR(v_rep, INSTR(v_rep,'_', -1)+1)||'?'||'server='||v_repserver, '_blank');
END IF;
END;

*****************************************************************************************************************
Note : Please not do make backups before using these queries and also confirm them yourself or by aother means as
 well.
*****************************************************************************************************************

***
Share

A glimpse Of Shaheed Kerbala

February 1st, 2013, posted in Muharram
Share

A wonderful blog where you would get a glimpse of Imam Aalee Muqaam… Imam Hussain (A.S)…Shaheed Kerbala​ :

http://www.sufiblog.com/#!imam-hussain/c157h

Share

If You Get What I Mean

January 31st, 2013, posted in BoYs, LoVE, MESSAGEs
Share

If You Get What I Mean,brother,love,respect,lover

Share

ORACLE : How to Add or Remove List Text Anywhere from List Item?

January 30th, 2013, posted in Oracle
Share

Here we will talk a trick of Oracle List Item for Forms Version 10g and 6i.

If you want to remove list text and values from a oracle forms list item.
How will you do this ?
When there is no remove icons and Backspace and Delete key doesn’t work, both just lest blank spaces.

Try the following shortcut keys:

  • “Ctrl + Shift + >” – add list element.
  • “Ctrl + Shift + <” – remove list element.
  • Share

    A Comic Of Jehan Ara

    January 29th, 2013, posted in COMiCS, PAKiSTAN
    Share

    A Comic Of Jehan Ara,comic,Jehan Ara,Jehan ,Ara,IT,Pasha

    Share