Quick Start

Rep2excel server is a HTTP server that contains Rep2excel (Oracle report to ms-excel converter) Utility.
Click here from more informatiom please!

1. Converting to oracle report in HTML/HTMLCSS format to ms-excel.
2. Splitting oracle report output in HTML/HTMLCSS format into multiple pages.
3. Mailing oracle report output via SMTP.(Click here)

How to Install

System requirement

Windows NT4/2000/XP/2003 or higher.
Microsoft Excel runtime.

Installation

If you downloaded a self-extracting setup file (r2esvr_xx.exe), just run the executable.
If you downloaded a zip file (r2esvr_xx.zip), extract it to a temporary directory, then execute r2esvr_setup.exe.

Setting up Rep2excel Server

1. Start Rep2excel Server. (You can use this command: net start "Rep2excel Server"
2. Visit this link http://<rep2excel-server-name:port>/. The home page of Rep2excel Server appear.
3. Please click the Rep2excel Server Manager, and then input the password, logon the Manager. The following page appears.
   

Common Setting Options:

• Default cache directory inbox.
  Specisfy the directory that contains the files generated by report server or downloaded from network.
• Hide Filepath parameter in URL that call Rep2excel
  If this box is checked, the filepath parameter will be encrypted in the URL.

Other Settings:

• Change password of Administrator.
  The default password is admin, you should change it after installing the server.
  If you forget the password, please logon the windows server, run Rep2excelSvr.exe -resetpwd to reset the password to admin.
   
• Setup the email account that is used to send report.
  (For more information, Click here)
   
• Change default parameter values for this server .
  (For more information, Click here)
   
• Change port of the server.
  You can change the port of the server through web page, however, we suggest you to change port through the Rep2excel Server Administrator instead

Note: The stared items are to be setup.

You can call Rep2excel through following 2 way: 

1. HTTP link 
2. Command line. For more information, please click here 

1. Make sure the Rep2excel server is running.
2. Input the file path of a html file output by Orealce Report server by URL. The file path may be path of file system of server, may be a http link to a file.
3. Rep2excel server return excel output thru browser.

Step by step guide:

1)Open the link below in browser: http://server_name/rep2excel.exe?job=getwebpage&pagename=index
2)Input a link to oracle report html output into the "File Path" inbox
Examples:
1, filepath=C:\orant\REPORT60\server\cache\reportoutput.htm
2, filepath=\\report_server\cache\reportoutput.htm
3, filepath=http://report_server:7777/cache/reportoutput.htm
4, filepath=/cache/reportoutput.htm
5, filepath=http://www.lv2000.com/examples/getreport.php?file=00001.htm&mime=text/html
6, filepath=/getreport.jsp?filename=reportoutput.htm
7, filepath=http://SVR_NAME:7777/dev60cgi/rwcgi60?server=rep_svr&report=test_report.rdf&userid=scott/tiger@test
&destype=cache&desformat=HTMLCSS
3)Click "Submit" button
4) Rep2excel server return excel to client-site browser.

Programming with Rep2excel Server

Call rep2excel from oracle forms from web.
You can call rep2excel from oracle forms using web.show_document built-in.
If you are now using web.show_document to open a HTML file generated by oracle report server, you can invoke rep2excel to get excel easily. [Demo Online]

The following sample code demonstrates how to change your code to work with rep2excel.
You original code:
declare v_url varchar2(1000); begin v_url := 'http://SVR_NAME:7777/dev60cgi/rwcgi60?server=rep_svr&report=test_report.rdf&userid=scott/tiger@test&destype=cache&desformat=HTMLCSS'; web.show_document(v_url,'_blank'); end;
Please change the first parameter of web.show_document, like this
declare v_url varchar2(1000); begin v_url := 'http://SVR_NAME:7777/dev60cgi/rwcgi60?server=rep_svr&report=test_report.rdf&userid=scott/tiger@test&destype=cache&desformat=HTMLCSS'; --Modify begin v_url:=encode_url(v_url);--Please don't omit this step; web.show_document('http://web-server:7777/cgi-bin/rep2excel.exe?filepath='||v_url||'&job=preview','_blank'); --Modify end end;

The URL encoding.

In an encoded string, blanks are changed into + and special characters are made by the % symbol, followed by the hexadecimal digits of the ASCII code.
For example the character "-" is substituted by the string "%2d".

The sample code of function encode_url is

FUNCTION encode_url(p_url varchar) RETURN varchar IS v_len number(5); v_cur number(5); v_url varchar2(2000):=NULL; v_chr varchar2(1); v_num number(3); v_num_high number(3); v_num_low number(3); BEGIN v_len := lengthb(p_url); v_cur:=1; loop exit when v_cur>v_len; v_chr := substrb(p_url,v_cur,1); v_num := ascii(v_chr); if v_num=32 then v_url:=v_url||'+'; elsif (v_num>=65 and v_num<=90) or (v_num>=97 and v_num<=122) or (v_num>=48 and v_num<=57) then v_url:=v_url||v_chr; else v_url:=v_url||'%'; v_num_high := floor(v_num/16); if v_num_high>=10 then v_chr:=chr(v_num_high+55); else v_chr:=chr(v_num_high+48); end if; v_url:=v_url||v_chr; v_num_low:=mod(v_num,16); if v_num_low>=10 then v_chr:=chr(v_num_low+55); else v_chr:=chr(v_num_low+48); end if; v_url:=v_url||v_chr; end if; v_cur:=v_cur+1; end loop; return v_url; END;

There is a example included in rep2excel installation patch. You can download the latest version
from http://www.lv2000.com/examples/run_rep_example.zip

Please click here for more information.

Rep2excel Server is running on the server site, when you call Rep2excel Server to handle your reports, It will occupy the resource of the hosting server. You can also export the client site program of Rep2excel server to local pc, and then run the client site program instead. The client site program occupy the resource of local computer.

How to export client site program of Rep2excel Server?

1) Start Rep2excel Server.
2) Open this link from client site in browser.
http://<server_name>:<port>/rep2excel.exe?job=getclientsite
3) Save the file to local disk.

How to use client site program of Rep2excel Server

The client site program of Rep2excel Server is Rep2excel Personal Edition.
Rep2excel Personal Edition support command line only!
Please use rep2excel --help to get the usage.

Rep2excel Server Administrator

1. Logon the windows server where Rep2excel Server is installed.
2. Run the Rep2excel Server Administrator.
   Path : Start menu/Programs/Rep2excel Server/Rep2excel Server Administrator

The differences between Rep2excel and Rep2excel Server.
1)
Rep2excel is a CGI application, it should be deploied in a web server.
Rep2excel server is web server that contains built-in Rep2excel utility.
2)
Rep2excel supports command line interface, you can use it thru command line.
Rep2excel server doesn't support command line, but the client site utility of
Rep2excel server (Rep2excel Persional Edition) supports command line interface.
3)
Rep2excel server is easy to use, easy to control, easy to extend.
Rep2excel requires users advanced computer skills.

Rep2excel or Rep2excel Server, which one suit me better?
Rep2excel server is the better choice for most users, but if you are skilled in Rep2excel re-development and you have many end users, Rep2excel should be the better choice for you.

How to register

How To Order
Please visit our ordering web site:
http://www.lv2000.com/order.htm
For more information, please contact <sales@lv2000.com>.

Registration Benefits

• Full license to use the software beyond the 30-day evaluation.
• Free upgrades .
• Free technical support by e-mail.