Information for advanced users and administrator
Some of our reports are very important and we don't want that they can be printed more than once. Therefore we needed a software that can enable us to send the print directly to printer. (If we give preview, user can get multiple prints or save it to some file like pdf, html to get the further prints later).
But the issue with RepExpert is if user opens RepExperts and changes the property 'Output directly to printer' or changes the URL parameters, the output will not go to the printer directly. So it should be restricted (password controlled or so)
One more thing we have many remote locations
and if someone uninstalls the RepExpert from his computer, the output
will come in the preview instead of printer.
Repexpert can output oracle report to printer directly, Repexpert can also hide the source code of HTML report.
You use web.show_document() bulti-in to show report output. If the link(URL) is caught by browser (e.g. MS-IE), end users can see the source code and save it.
There is a solution to solve this problem.
1) Encrypt the link(URL) in your forms, pass the encrypted URL to a redirect script named 'getreports.jsp' ;
You can change to sample code to :
4) Repexpert use the original link to download report output files.
Please click here to download the example.
The RepExpert has to be installed and configured on every pc. Configuration means the url settings and property 'Output directly to printer'. Installation is not the problem for an ordinary user as it is wizard based but configuration should not be done on every pc. Some config file should be copied to the newly installed pc and the things should be done automatically.
About the url settings:
Since version 1.3.3, RepExpert will catch all URLs contains '&callrepexpert=yes' . So if you append the url link to oracle report with '&callrepexpert=yes' . For example :
web.show_document( v_url||'&callrepexpert=yes' ,'_blank');
You do not need to config the kewords of url on every pc that hosting RepExpert.
About the property 'Output directly to printer' .
You can Modify RDF file to print special report directly without delay. See the page below please
encrypt_url(p_url varchar) RETURN varchar IS
--TODO : Change the encryption algorithm, you should change the corresponding decryption algorithm
-- in getreports.jsp
v_len := lengthb(p_url);
exit when v_cur>v_len;
v_chr := substrb(p_url,v_cur,1);
v_num := ascii(v_chr);
if v_num=32 then
elsif (v_num>=65 and v_num<=90) THEN -- A - Z
elsif (v_num>=97 and v_num<=122) THEN -- a - z
ELSIF (v_num>=48 and v_num<=57) THEN -- 0 - 9
--encrypt the number
-- 0 -> 1
-- 1 -> 6
-- 2 -> 3
-- 3 -> 8
-- 4 -> 5
-- 5 -> 9
-- 6 -> 4
-- 7 -> 0
-- 8 -> 2
-- 9 -> 7
IF v_chr IN ('0','2','4') THEN
v_chr := v_chr+1;
ELSIF v_chr IN ('1','3') THEN
v_chr := v_chr+5;
ELSIF v_chr IN ('6','9') THEN
v_chr := v_chr-2;
ELSIF v_chr = '5' THEN
v_chr := '9' ;
ELSIF v_chr = '7' THEN
v_chr := '0' ;
ELSIF v_chr = '8' THEN
v_chr := '2' ;
END IF ;