42 Building a Report with a Barcode

42.1.1 Update the REPORTS_CLASSPATH environment variable

Before you use a JavaBean (for a paper-based or JSP-based Web report), you need to perform several steps.

In this section, you will update the REPORTS_CLASSPATH environment variable with the location of the JavaBean. When you launch Reports Builder, it will use this new class path to recognize the location of the barcode bean.

1. Find the REPORTS_CLASSPATH environment variable:

   • On Windows, open the registry from a command prompt by typing regedit and locate the REPORTS_CLASSPATH environment variable. You may want to make a backup of your registry before modifying it.

   • On UNIX, locate the REPORTS_CLASSPATH environment variable in ORACLE_HOME/bin/reports.sh.

2. Append the location of the oraclebarcode.jar file to the existing entries in REPORTS_CLASSPATH, for example:

   • On Windows:

     Examples\BarcodeBeanPaper\scripts\oraclebarcode.jar
     
     

   • On UNIX:

     Examples/BarCodeBeanPaper/scripts/oraclebarcode.jar
     

   
   

   Note: The path depends on where the files are located. If you downloaded the files from the Oracle Technology Network (http://www.oracle.com/technology/products/reports/), you may have to further edit this path. Also, when you edit the Windows registry, make sure you separate your entries with a semicolon (;), with no spaces on either side of the semicolon.

   
   

You are now ready to begin building your report. To learn how to create a paper-based barcode report, refer to Section 42.2, "Create a barcode report for paper". To learn how to create a JSP-based barcode report for the Web, refer to Section 42.3, "Create a barcode report for the Web".

42.2.1 Import the Java classes into Reports Builder

To create a paper report using the barcode JavaBean, you must first import two Java classes into Reports Builder. When you import these Java classes, Reports Builder automatically creates the packages you need to build the report.

To import the Java classes:

1. Launch Reports Builder.

   
   

   Note: You must launch Reports Builder now so that the new REPORTS_CLASSPATH is used.

   
   

2. Close the Welcome dialog box by clicking Cancel.

3. Choose Program > Import Java Classes to display the Import Java Classes dialog box.

4. Under Select Java Classes, navigate to:

   oracle.apps.barcode.util.BarCodeConstants
   
   

   
   

   Note: If you do not see this class listed, try exiting Reports Builder and make sure the REPORTS_CLASSPATH reads correctly. Then, launch Reports Builder again.

   
   

5. Select the class, then click Import.

6. Once the packages have been created, import the second JavaBean: oracle.apps.barcode.BarCodeMaker.

7. Click Close.

8. In the Object Navigator, under the report named MODULE 1, click the Program Units node. You will notice that Reports Builder created two package specifications and two package bodies named BARCODECONSTANTS and BARCODEMAKER.

42.2.2 Create a package to store your information

In this report, you want to create a package where the information will be stored.

To create a package for storing your information:

1. In the Object Navigator, under your new report, click the Program Units node.

2. Click the Create button in the toolbar to display the New Program Unit dialog box.

3. In the New Program Unit dialog box, type globals.

4. Select Package Spec, then click OK to display the PL/SQL Editor:

5. In the PL/SQL Editor, type the following code:

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

   
   

   Note: You can also enter this code by copying and pasting it from the provided text file called barcode_code.txt.

   
   

6. Click Compile to make sure there are no errors in your code.

   
   

   Note: If your code does not compile, make sure you have typed in exactly the code we have provided.

   
   

7. Once the code is compiled, click Close.

8. In the Object Navigator, click your report name (for example, MODULE 1).

9. Save the report as shippingmanifest_your_initials.rdf.

You have created a package that will contain the global information for your report.

42.2.3 Create a Before Report trigger

You can use a Before Report trigger to perform specific tasks before the report is run. Here, you will define the type of barcode you want to use in your report, as well as the temporary directory where your barcode images will be stored.

To create a Before Report trigger:

1. In the Object Navigator, under SHIPPINGMANIFEST_your_initials, expand the Report Triggers node, then double-click the icon next to BEFORE REPORT to display the PL/SQL Editor.

2. In the PL/SQL Editor, use the template to enter the following PL/SQL code:

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

   To modify the type of barcode you want to use, you can change the value BarCodeConstants.BAR_CODE_128 to any other valid value. To determine which values are valid, check the contents of the package by opening the BarCodeConstants package spec in the Object Navigator, under the Program Units node.

   
   

   Note: You can enter this code by copying and pasting it from the provided text file called barcode_code.txt.

   
   

3. Click Compile to make sure there are no errors.

   
   

   Note: If you have errors, make sure you have imported the necessary Java classes and compare your code closely with the code above. If you change the code, be sure to compile it again.

   
   

4. When the code is compiled, click Close. Notice how the node icon next to the BEFORE REPORT trigger has changed.

5. Save your report.

You have created a trigger that will set up the barcode type for you when you run the report.

42.2.4 Create a query in the Data Model view

In this section, you will manually create the query that the report will use to retrieve data from the sample schema.

To create the query:

1. In the Object Navigator, under SHIPPINGMANIFEST_your_initials, double-click the view icon next to the Data Model node to display the Data Model view for your report.

2. In the Data Model view, click the SQL Query tool in the tool palette, then click in an open area of the Data Model view to display the SQL Query Statement dialog box.

3. In the SQL Query Statement field, enter the following SELECT statement:

   SELECT ALL CUSTOMERS_A1.CUST_FIRST_NAME, 
     CUSTOMERS_A1.CUSTOMER_ID, CUSTOMERS_A1.CUST_LAST_NAME,
     CUSTOMERS_A1.CUST_ADDRESS.STREET_ADDRESS,
     CUSTOMERS_A1.CUST_ADDRESS.POSTAL_CODE, 
     CUSTOMERS_A1.CUST_ADDRESS.CITY,
     CUSTOMERS_A1.CUST_ADDRESS.STATE_PROVINCE, 
     CUSTOMERS_A1.CUST_ADDRESS.COUNTRY_ID, ORDERS.ORDER_ID,
     ORDERS.ORDER_DATE, 
     ORDERS.ORDER_TOTAL, ORDER_ITEMS.LINE_ITEM_ID,
     PRODUCTS.PRODUCT_NAME, 
     ORDER_ITEMS.UNIT_PRICE, ORDER_ITEMS.QUANTITY,
     COUNTRIES.COUNTRY_NAME
   FROM CUSTOMERS CUSTOMERS_A1, ORDER_ITEMS, ORDERS,
     PRODUCTS, HR.COUNTRIES
   WHERE ((ORDER_ITEMS.ORDER_ID = ORDERS.ORDER_ID)
     AND (ORDERS.CUSTOMER_ID = CUSTOMERS_A1.CUSTOMER_ID)
     AND (ORDER_ITEMS.PRODUCT_ID = PRODUCTS.PRODUCT_ID)
     AND (CUSTOMERS_A1.CUST_ADDRESS.COUNTRY_ID =
     HR.COUNTRIES.COUNTRY_ID)) 
     AND ORDERS.ORDER_ID = :P_ORDER_ID
   ORDER BY order_ID, line_item_ID
   
   

   
   

   Note: You can enter this query in any of the following ways: Copy and paste the code from the provided text file called barcode_code.txt into the SQL Query Statement field. Type the code in the SQL Query Statement field.

   
   

4. Click OK.

   If you are not connected to a database that contains the sample schema we have provided, you must log in now. If you are not sure what your connection string is, contact your database administrator. Note that this example uses the Order Entry sample schema.

5. When a message displays indicating that the bind parameter p_order_id was created, click OK.

6. In the data model you just created, select all of the following columns using Shift-click, then drag them below the current query to create a detail group:

   • LINE_ITEM_ID

   • PRODUCT_NAME

   • UNIT_PRICE

   • QUANTITY

   The resulting data model should look like this:

   Figure 42-2 Data Model for the query

   
   Description of "Figure 42-2 Data Model for the query"
   
   

42.2.5 Create a formula column to retrieve the barcode image

In this section, you will create a formula column that will communicate with the JavaBean to create the barcode, then return the file name of the generated image.

To create a formula column:

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

2. Click in the master group (G_CUST_FIRST_NAME) to create a new formula column.

3. Double-click the new formula column object (CF_1) to display the Property Inspector, and set the following properties:

   • Under General Information, set the Name property to ImageFilename.

   • Under Column:

     • Set the Datatype property to Character

     • Set the Width property to 500

     • Set the Read from File property to Yes

     • Set the File Format property to Image

   • Under Placeholder/Formula, click the PL/SQL Formula property field to display the PL/SQL Editor.

4. In the PL/SQL Editor, use the template to enter the following PL/SQL code:

   function ImageFilenameFormula return VarChar2 is
     myFileName varchar2(500);
     result varchar2(500);
     barcodeData VarChar2(50) := :customer_ID || :order_ID;
   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;
   

   
   

   Note: You can enter this code by copying and pasting it from the provided text file called barcode_code.txt.

   
   

5. Click Compile to make sure there are no errors.

   
   

   Note: If you have errors, make sure you have imported the necessary Java classes and compare your code closely with the code above. If you change the code, be sure to compile it again.

   
   

6. When the code is compiled, click Close.

42.2.6 Create a formula column that returns the order total

To create the second formula column:

1. In the Data Model view, create a formula column in the detail group G_LINE_ITEM_ID.

2. Open the Property Inspector for the formula column, and set the following properties:

   • Under General Information, set the Name property to LineTotal.

   • Under Column, make sure the Datatype property is set to Number.

   • Under Placeholder/Formula, click the PL/SQL Formula property field to display the PL/SQL Editor.

3. In the PL/SQL Editor, use the template to enter the following PL/SQL code:

   function LineTotalFormula return Number is
   begin
     return (:quantity * :unit_price);
   end;
   

   
   

   Note: You can enter this code by copying and pasting it from the provided text file called barcode_code.txt.

   
   

4. Click Compile to make sure there are no errors.

5. When the code is compiled, click Close.

6. Save the report.

You have created the data model for your barcode report, which contains a formula column that retrieves the barcode information and displays the barcode image on your report, and another formula column that displays the order total.

Your data model and the PL/SQL for the formula column should look similar to this:

Figure 42-3 Data Model with two new formula columns

Description of "Figure 42-3 Data Model with two new formula columns"

42.2.7 Create a layout for your report

Before you can run your report, you must create a layout.

To create a paper layout:

1. Under your report's node in the Object Navigator, right-click Paper Layout, then choose Report Wizard.

2. In the Report Wizard, on the Report Type page, select Create Paper Layout Only, then click Next.

3. On the Style page, select Group Above, then click Next.

4. On the Data Source page, click Next.

5. On the Data page, click Next.

6. On the Groups page, make sure the following fields are listed in the Group Fields list (if not, use the arrows to move the field to the appropriate list):

   • ORDER_ID

   • ORDER_DATE

   • CUSTOMER_ID

   • CUST_FIRST_NAME

   • CUST_LAST_NAME

   • STREET_ADDRESSS

   • POSTAL_CODE

   • COUNTRY_NAME

   • CITY

   • STATE_PROVINCE

   • COUNTRY_ID

   • ORDER_TOTAL

   • CF_1

7. On the Fields page, click the double right arrows (>>) to move all of the fields to the Displayed Fields list, then click Finish.

8. In the Paper Layout view, click the Run Paper Layout button in the toolbar to run your report.

9. In the Runtime Parameter Form, next to P_ORDER_ID, type 2354.

10. Once your report displays in the Paper Design view, you can rearrange your layout objects in the Paper Layout view to make your report look something like Figure 42-4. To create this format:

    • In the Paper Layout view, remove the surrounding parent frame M_G_CUST_FIRST_NAME_GRPFR, then click the Confine Off button and the Flex Off button in the toolbar.

    • Using the shippingmanifest.rdf example report as a guide, add three rectangles and three text objects for:

      • Shipping Details: Set text properties to Arial, 16, bold. Create a frame to add the following fields: cust_first_name, cust_last_name, street_address, city, state_province, postal, country_name.

      • Tracking Details: Set text properties to Arial, 16, bold. Move the ImageFilename object onto this rectangle.

      • Order Details: Set text properties to Arial, 16, bold. Move the labels and fields for Order ID and Order Date onto this rectangle. Move the field F_Order_Total onto this rectangle and set text properties to Courier New, 24, bold.

    • Set the text properties for all other field values to Courier New, 10. Additionally, set F_Line_Total to bold.

    • Format numeric field values to display currency, decimals, and right align them.

    • Set Fill Color for each rectangle, totals field, and table header as desired.

    Figure 42-4 Paper Design view of the barcode paper report

    
    Description of "Figure 42-4 Paper Design view of the barcode paper report"
    
    
    
    

    Note: If you are not sure whether you produced the desired results, you can always open the example report called ShippingManifest.pdf in Acrobat Reader. Or, you can run ShippingManifest.rdf to paper and the report will display in the Paper Design view.

    
    

11. Save the report. You have now finished building a barcode report for paper.

42.3.1 Create a query in an existing HTML file

When you create a JSP-based Web report, you can use an existing HTML file as a template. The steps in this section will show you how to open an HTML file in Reports Builder and add data to it.

To create a query in an existing HTML file:

1. In Reports Builder, choose File > Open and open the file Examples\BarCodeBeanWeb\source\ShippingLabel.html.

2. In the Object Navigator, under SHIPPINGLABEL, double-click the view icon next to the Data Model node to display the Data Model view for the report.

3. In the Data Model view, click the SQL Query tool in the tool palette, then click in an open area of the Data Model view to display the SQL Query Statement dialog box.

4. In the SQL Query Statement field, enter the following SELECT statement:

   SELECT ALL CUSTOMERS_A1.CUST_FIRST_NAME,
     CUSTOMERS_A1.CUSTOMER_ID, CUSTOMERS_A1.CUST_LAST_NAME,
     CUSTOMERS_A1.CUST_ADDRESS.STREET_ADDRESS,
     CUSTOMERS_A1.CUST_ADDRESS.POSTAL_CODE,
     CUSTOMERS_A1.CUST_ADDRESS.CITY,
     CUSTOMERS_A1.CUST_ADDRESS.STATE_PROVINCE,
     CUSTOMERS_A1.CUST_ADDRESS.COUNTRY_ID,
     ORDERS.ORDER_ID, ORDERS.ORDER_DATE, ORDERS.ORDER_TOTAL,
     COUNTRIES.COUNTRY_NAME FROM CUSTOMERS CUSTOMERS_A1, ORDERS,
     HR.COUNTRIES
   WHERE ((ORDERS.CUSTOMER_ID = CUSTOMERS_A1.CUSTOMER_ID)
     AND (CUSTOMERS_A1.CUST_ADDRESS.COUNTRY_ID = HR.COUNTRIES.COUNTRY_ID))
     AND ORDERS.ORDER_ID = :P_ORDER_ID ORDER BY order_ID 
   

   
   

   Note: You can enter this query in any of the following ways: Copy and paste the code from the provided text file called barcode_code.txt into the SQL Query Statement field. Type the code in the SQL Query Statement field.

   
   

5. Click OK.

   If you are not connected to a database that contains the sample schema we have provided, you must log in now. If you are not sure what your connection string is, contact your database administrator. Note that this example uses the Order Entry sample schema.

6. When a message displays indicating that the bind parameter was created, click OK.

7. In the Data Model view, double-click the group object to display the Property Inspector, and set the following properties:

   • Under General Information, set the Name property to G_SHIPMENT.

   Your data model should look something like this:

   Figure 42-5 Data Model for the JSP-based Web report query

   
   Description of "Figure 42-5 Data Model for the JSP-based Web report query"
   
   

8. Save your report as ShippingLabel_your_initials.jsp to create the JSP-based Web source for this report.

You have now created the query that will pull in the data for your report.

42.3.2 Create three formula columns in your data model

You will need to create three formula columns in your report to retrieve the tracking number for the order, the origin of the order, and the destination for the order.

To create the TrackingNumber formula column:

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

2. Click in the G_SHIPMENT group to create a new formula column.

3. Double-click the new formula column object (CF_1) to display the Property Inspector, and set the following properties:

   • Under General Information, set the Name property to TrackingNumber.

   • Under Column, set the Datatype property to Character.

   • Under Placeholder/Formula, click the PL/SQL Formula property field to display the PL/SQL Editor.

4. In the PL/SQL Editor, use the template to enter the following PL/SQL code:

   function TrackingNumberFormula return char is
   begin
       return(:Customer_id||:Order_ID||:country_ID);
   end;
   

   
   

   Note: You can enter this code by copying and pasting it from the provided text file called barcode_code.txt.

   
   

5. Click Compile.

   
   

   Note: If your code does not compile, make sure you have typed in exactly the code we have provided.

   
   

6. When the code is compiled, click Close.

To create the OriginScan formula column:

1. Create another formula column in the G_SHIPMENT group.

2. Double-click the new formula column object (CF_1) to display the Property Inspector, and set the following properties:

   • Under General Information, set the Name property to OriginScan.

   • Under Column, set the Datatype property to Character.

   • Under Placeholder/Formula, click the PL/SQL Formula property field to display the PL/SQL Editor.

3. In the PL/SQL Editor, use the template to enter the following PL/SQL code:

   function OriginScanFormula return char is
   begin
     return('34324-OH-US');
   end;
   
   

   
   

   Note: You can enter this code by copying and pasting it from the provided text file called barcode_code.txt.

   
   

4. Click Compile.

   
   

   Note: If your code does not compile, make sure you have typed in exactly the code we have provided.

   
   

5. When the code is compiled, click Close.

To create the DestinationScan formula column:

1. Create a third formula column in the G_SHIPMENT group.

2. Double-click the new formula column object (CF_1) to display the Property Inspector, and set the following properties:

   • Under General Information, set the Name property to DestinationScan.

   • Under Column, set the Datatype property to Character.

   • Under Placeholder/Formula, click the PL/SQL Formula property field to display the PL/SQL Editor.

3. In the PL/SQL Editor, use the template to enter the following PL/SQL code:

   function DestinationScanFormula return char is
   begin
   return(:postal_code||'-'||:state_province||'-'||:country_ID);
   end;
   
   

   
   

   Note: You can enter this code by copying and pasting it from the provided text file called barcode_code.txt.

   
   

4. Click Compile.

   
   

   Note: If your code does not compile, make sure you have typed in exactly the code we have provided.

   
   

5. When the code is compiled, click Close.

6. Save your report as a JSP.

You have created the three formula columns that will hold the values for the tracking number, the origin, and the destination of the order. Your data model should look something like this:

Figure 42-6 Data Model with the three formula columns

Description of "Figure 42-6 Data Model with the three formula columns"

42.3.3 Initialize the barcode JavaBean and set its properties

To enable your JSP-based Web report to communicate with the JavaBean, you need to initialize it in the JSP. Unlike using the JavaBean with a paper report, you do not need to use the Java importer to import the Java classes.

In this section, you will also learn how to set the properties for the bean so that the correct data is being used to produce the barcode.

If you do not want to bother with typing the code in yourself, you can always open the source file (Examples/BarCodeBeanWeb/source/ShippingManifestWeb.rdf) and copy the appropriate pieces of the Web source into your report.

To ensure that the JavaBean references the correct barcode images, you must first update your report with the correct path.

To update the paths:

1. In the Object Navigator, double-click the view icon next to the Web Source node for your JSP-based Web report (ShippingLabel_your_initials) to display the Web Source view.

2. In the Web Source view, look for the text: Define Path information for your barcode images.

3. Under this text, update the paths to make sure they point to the directories where your images will be generated (for example, d:\\temp\\docroot\\images\\). Be sure to maintain the integrity of the paths we have provided.

   
   

   Note: The directory where these files are located must be accessible by the Web server. This directory is typically located somewhere below the directory where you keep your JSPs. Make sure that this directory exists on your computer before you run the report to the Web.

   
   

To initialize the JavaBean:

1. In the Web Source view, look for the text: initialize the java beans.

2. Under this text, type the following code:

   <jsp:useBean id="BC" scope="page" class="oracle.apps.barcode.util.BarCodeConstants" />
   <jsp:useBean id="BM" scope="page" class="oracle.apps.barcode.BarCodeMaker" />
   

   
   

   Note: You can enter all the code in this section by copying and pasting it from the provided text file called barcode_code.txt.

   
   

To set the barcode JavaBean properties:

1. In the Web Source view, look for the text: setting the barcodes properties.

2. Under this text, type the following code:

   <jsp:setProperty name="BM" property="BarCodeType" value="<%= BC.BAR_CODE_128 %>" />
   <jsp:setProperty name="BM" property="BarWidthInch" value="0.01"/>
   <jsp:setProperty name="BM" property="Directory" value="<%= BarcodePhysicalPath %>"/>
   

To define the barcode variables:

1. In the Web Source view, look for the text: Define variables to hold the data for the three barcodes.

2. Under this text, type the following code:

    <%! private String BarCodeData1 = "12345-XX-XX"; %>
    <%! private String BarCodeData2 = "12345-XX-XX"; %>
    <%! private String BarCodeData3 = "12345-XX-XX"; %>
   

To create a For Each loop:

1. In the Web Source view, look for the text: replace this with your RW:FOREACH open tag.

2. Replace this line with the following code:

   <rw:foreach id="R_G_SHIPMENT" src="G_SHIPMENT">
   

3. Look for the text: replace this with your RW:FOREACH close tag.

4. Replace this line with the following code:

   </rw:foreach>
   

To code the formula columns to render the barcodes:

1. In the Web Source view, look for the text: **BARCODEShippingTrackingNumber**.

2. Under this text, type the following code:

   <!-- Get the value of the TrackingNumber and assign it to the variable -->
   <rw:getValue id="BarCodeData1" src="TrackingNumber"/>
   <!-- Set the data for tbe barcode and the filename -->
   <jsp:setProperty name="BM" property="BaseCodeData" value="<%= BarCodeData1 %>"/>
   <jsp:setProperty name="BM" property="FileName" value="<%= BarCodeData1 %>"/>
   <!-- Render the barcode -->
   <% BM.renderBarCode(); %>
   <!-- View the image in the page -->
   <img src="assets/barcodes/<%= BarCodeData1 %>">
   
   

   
   

   Note: The lines beginning with "<!--" are comments. If you do not want comments in your code, you do not have to add these lines.

   
   

3. In the Web Source view, look for the text: **BARCODEOriginScan**.

4. Under this text, type the following code:

   <!-- Get the value of the OriginScan and assign it to the variable -->
   <rw:getValue id="BarCodeData2" src="OriginScan"/>
   <!-- Set the data for tbe barcode and the filename -->
   <jsp:setProperty name="BM" property="BaseCodeData" value="<%= BarCodeData2 %>"/>
   <jsp:setProperty name="BM" property="FileName" value="<%= BarCodeData2 %>"/>
   <!-- Render the barcode -->
   <% BM.renderBarCode(); %>
   <!-- View the image in the page -->
   <img src="assets/barcodes/<%= BarCodeData2 %>">
   

5. In the Web Source view, look for the text: **BARCODEDestinationScan**.

6. Under this text, type the following code:

   <!-- Get the value of the DestinationScan and assign it to the variable -->
   <rw:getValue id="BarCodeData3" src="DestinationScan"/>
   <!-- Set the data for tbe barcode and the filename -->
   <jsp:setProperty name="BM" property="BaseCodeData" value="<%= BarCodeData3 %>"/>
   <jsp:setProperty name="BM" property="FileName" value="<%= BarCodeData3 %>"/>
   <!-- Render the barcode -->
   <% BM.renderBarCode(); %>
   <!-- View the image in the page -->
   <img src="assets/barcodes/<%= BarCodeData3 %>">
   

7. Save your report as a JSP.

42.3.4 Run your report to the Web

Since you have created a Web report, you must run this report to the Web to see your results.

1. In the Object Navigator, click your report name, ShippingLabel_your_initials.

2. Click the Run Web Layout button in the toolbar to run your report to a browser.

   
   

   Notes: If Netscape 7.0 is your default browser, and the browser does not display, set the registry key HKEY_CURRENT_USERS\Software\Oracle\Toolkit\Tkbrowser to the default browser location. Ensure that the BrowserName and the BrowserPath keys reflect the correct values. For example: BrowserName=Netscape 7; BrowserPath=C:\Program Files\Netscape\Netscape\Netscp.exe. If Run Web Layout fails with an error related to the major.minor version, you will need to update the environment variables CLASSPATH or REPORTS_CLASSPATH, as follows: remove the 9.0.x ORACLE_HOME specification in the oc4j.jar file path (the oc4j.jar file path should specify only the 10g Release 2 (10.1.2) ORACLE_HOME).

   
   

   Your report displays in your Web browser, and should look something like this:

Figure 42-7 Snapshot of the final JSP-based Web report with barcode

Description of "Figure 42-7 Snapshot of the final JSP-based Web report with barcode"