SOLUTION: Barcode Javabean demo

Download the Barcode Javabean demo from OTN.

1) Unzip the contents of the zip file into a directory.

2) Edit the reports.sh file, and add the path of the oraclebarcode.jar to the REPORTS_CLASSPATH variable in the
reports.sh file.
For example :

REPORTS_CLASSPATH = /oracle/usupport/dev9i/reports/barcode/scripts/oraclebarcode.jar

3) Create a simple report based on emp table using barcode bean.
These are the steps:

a) Launch Report Builder and click on Program -> Import Java classes.

b) Select oracle.apps.barcode.util.BarCodeConstants, then click Import.Once the packages have been created,
import the second JavaBean: oracle.apps.barcode.BarCodeMaker.

c) Make sure the corresponding program units are created.

d) Create a Package named Globals as follows:

 

PACKAGE globals IS
bcobj ora_java.jobject;
barcode_to_use varchar2(256);
tempdir varchar2(100);
directory_sep varchar2(2);
END;

e) Save the report and then create a BeforeReport Trigger as follows:
 

begin
globals.barcode_to_use := BarCodeConstants.BAR_CODE_128;
globals.bcobj := barcodemaker.new();
return (TRUE);
end;

f) Save the report and then create a query in data model with SQL "select * from emp" using the scott schema.

g) Drag the deptno column down into a detail group.


4) Create formula column (CF_1) in the master as follow :

a) In the Data Model view, click the Formula Column tool in the tool palette.

b) Click in the master group (the main group that still contains most of the column names) 
to create a new formula column.

c) Double-click the new formula column object (CF_1) to display the PropertyInspector, and set properties:

Under Column, set the Datatype property to Character.
Under Placeholder/Formula, click the PL/SQL Formula property field to display the PL/SQL Editor.

d) In the PL/SQL Editor, use the template to enter the following PL/SQL code:
 

function CF_1Formula return VarChar2 is
myFileName varchar2(500);
result varchar2(500);
barcodeData VarChar2(50) := :empno || :deptno;
begin
myFileName := srw.create_temporary_filename;
barcodemaker.setBarWidthInch(globals.bcobj, 0.005);
barcodemaker.setBaseCodeData(globals.bcobj,barcodeData);
barcodemaker.setBarCodeType(globals.bcobj,globals.barcode_to_use);
barcodemaker.setFullPath(globals.bcobj, myFileName);
barcodemaker.renderBarCode(globals.bcobj);
return(myFileName);
end;

e)Under Column, set the Read from File property to Yes, and set the File Format property to Image.

5) Now create a Paper layout using the Report Wizard. Choose the Group above option as Style.

Save the report and run it from Builder to check if this works.

In the repserv.conf file, add the classPath as follows:

 

<engine id="rwEng" class="oracle.reports.engine.EngineImpl" initEngine="1" 
maxEngine="1" minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="60000" 
classPath="/oracle/usupport/dev9i/reports/barcode/scripts/oraclebarcode.jar">

Restart Report Server. Run the report using the Report Server

6) For Reports 10g (9.0.4) set the REPORTS_DEFAULT_DISPLAY=NO and define the DISPLAY variable
in unix environments, because the barcode java bean require a valid display.