| run reports in excel format in Report Builder 9.0.4.0.21 [message #379541] |
Wed, 07 January 2009 00:15  |
|
|
hi ,
i am using Report Builder 9.0.4.0.21.
i want to run my report in excel format , but i am not getting a solution to run in excel .
Is there any procedure or any kind of solution to run my report in excel format.
i am using Oracle 10G as database.
I hope i will get a positive responce.
thanks.
|
|
|
|
|
|
| Re: run reports in excel format in Report Builder 9.0.4.0.21 [message #383051 is a reply to message #381147] |
Tue, 27 January 2009 02:08  |
|
|
thanks prakash for the solution.
rep2excel is converting htm reports to excel format.
but the method i used is , excel report is saved in the server
and then it is opened . which is working fine in server system.
but when i open the same report in client system, excel report
is opening in server system but not in client system.
it is because ,i have mentioned the path of excel report in server.
the solution for this is that i must mention the output path as the client address.
but how can i know the client address as client system can be in any number.
I also want to know ,that is there any coding to open an excel report from server system to a client system so that the excel report can be opened in client system.
i am also sending u the code
DECLARE
v_rep2excel_path varchar2(100) := 'C:/DevSuiteHome/Apache/Apache/conf/rep2excel.exe';
v_cmd_rep2excel varchar2(300);
pl_id ParamList;
frm_name varchar2(50);
rep_name varchar2(50);
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
NM VARCHAR2(10);
REP_STATUS VARCHAR2(30);
V_INPUT_PATH VARCHAR2(150);
V_OUTPUT_PATH VARCHAR2(150);
FILENAME VARCHAR2(30);
BEGIN
FILENAME:='SALES_CONTRACT1.XLS';
repid := find_report_object('REPORT99');
v_rep := RUN_REPORT_OBJECT(repid);
rep_status := REPORT_OBJECT_STATUS(v_rep);
SELECT TO_NUMBER(substr(V_REP,instr(V_REP,'_')+1)) INTO NM FROM DUAL;
V_INPUT_PATH:='http://192.168.0.12:8889/reports/rwservlet/getjobid'||nm||'?server=cir';
V_OUTPUT_PATH:='E:\MAIN\EXCEL_REPORT\'||FILENAME;
v_cmd_rep2excel:='cmd /c start '||v_rep2excel_path||' -i:'||v_input_path ||' -o:'||v_output_path ||' -open' ;
:cmd2 := v_cmd_rep2excel;
HOST(v_cmd_rep2excel);
end;
i hope u will give me a solution.
[Updated on: Tue, 27 January 2009 02:11] Report message to a moderator |
|
|
|
| Re: run reports in excel format in Report Builder 9.0.4.0.21 [message #383915 is a reply to message #383051] |
Sat, 31 January 2009 03:55 |
|
|
hi , is there any one who can give me solution of the above problem.
I am able to convert htm report to excel format through rep2excel , that excel report is also saved in server system,but
how can a client system can access the excel report that is present in server system.
i want that excel report opened in the client system.
i would be really thankfull ,if somebody provide me a solution.
i am using Report Builder 9.0.4.0.21.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
