Home » Developer & Programmer » Reports & Discoverer » run reports in excel format in Report Builder 9.0.4.0.21 (Report Builder 9.0.4.0.21 , windows XP , database:- Oracle 10G)
run reports in excel format in Report Builder 9.0.4.0.21 [message #379541] Wed, 07 January 2009 00:15 Go to next message
vivekbhatt23
Messages: 5
Registered: January 2009
Location: delhi
Junior Member

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 #381147 is a reply to message #379541] Thu, 15 January 2009 07:43 Go to previous messageGo to next message
sharma.prakashkumar
Messages: 2
Registered: January 2009
Location: india
Junior Member

I thing it hepful for you.

http://oracle.anilpassi.com/how-to-open-using-excel-spreadsheets-directly-from-the-concurrent-re.html

http://garethroberts.blogspot.com/2007/09/standard-report-to-csv-file-via-bi.html
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 Go to previous messageGo to next message
vivekbhatt23
Messages: 5
Registered: January 2009
Location: delhi
Junior Member

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 Go to previous message
vivekbhatt23
Messages: 5
Registered: January 2009
Location: delhi
Junior Member

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.
Previous Topic: Calling parameter report from form
Next Topic: Closing Report in After-Report-Trigger
Goto Forum:
  


Current Time: Thu Dec 08 04:20:12 CST 2016

Total time taken to generate the page: 0.12152 seconds