Display Oracle Report in Excel/SpreadSheet:-
A complete syntax example to run Reports from a browser looks like this:-
http://<server>:<port>/reports/rwservlet? keyname&report=<report>.rdf&desformat=[htmlcss|pdf|xml|delimited|]&destype=cache¶mform=[no|yes]
In the cgicmd.dat file define the keyname as :-
testxls: userid=test/test@testdb destype=cache desformat=spreadsheet %*
DECLARE
REP_NAME varchar2 (2000);
rep_url varchar2 (4000);
BEGIN
REP_NAME:='d:\ PROJECTS\ code\'||'MYFIRSTREPORT.rdf';
rep_url:='http://localhost:8890'||'/reports/rwservlet?testxls&module='||REP_NAME
||'&p_emp_code='||:BLOCK_NAME.EMP_CODE;
WEB.SHOW_DOCUMENT(rep_url,'_blank');
END;
At runtime the program will ask you to open the excelsheet ,open it and you can see the out put in excel format.
A complete syntax example to run Reports from a browser looks like this:-
http://<server>:<port>/reports/rwservlet? keyname&report=<report>.rdf&desformat=[htmlcss|pdf|xml|delimited|]&destype=cache¶mform=[no|yes]
In the cgicmd.dat file define the keyname as :-
testxls: userid=test/test@testdb destype=cache desformat=spreadsheet %*
DECLARE
REP_NAME varchar2 (2000);
rep_url varchar2 (4000);
BEGIN
REP_NAME:='d:\ PROJECTS\ code\'||'MYFIRSTREPORT.rdf';
rep_url:='http://localhost:8890'||'/reports/rwservlet?testxls&module='||REP_NAME
||'&p_emp_code='||:BLOCK_NAME.EMP_CODE;
WEB.SHOW_DOCUMENT(rep_url,'_blank');
END;
At runtime the program will ask you to open the excelsheet ,open it and you can see the out put in excel format.
Hi...
ReplyDeleteWe have an application on Oracle 10g AS (10.1.2.0.2) and 11g DB.
While accessing the application user is able to see the complete URL in the browser like:
http://10.0.0.238:7778/SCCSM/adviceAction.do?FormId=MM075
We want to hide the URL in the browser, while accessing the application.
Is there any way out or configurations that can be done in the Application Server to make the URL is invisible.
Very Thanks in advance !!
I guess this link will help you
ReplyDeletehttp://docs.oracle.com/cd/B14099_19/web.1012/b14032/configure006.htm
you can do configuration in forsweb.cfg file.
Another option is you can use webutil.