Skip to content

Inventory Items Listing

This page is going to show you how to create the Inventory Items Listing web report.

  1. Click on the Create New button on the Studio’s toolbar.
  2. Click on the Web Object tab of the Create New... dialog.

  3. Double-click the WBO Report Wizard icon.

  4. Read the explanations on the first wizard page of what this wizard will do and click Next.

  5. On the Names wizard page, enter oInventoryItems as the object name, InventoryItems as the filename, and Inventory Items Listing as the description. Click Next.

  6. On the "Main Data Dictionary" wizard page, click on Invt - Invt_DataDictionary to select it as the data dictionary to be used, then click Next.

  7. On the "Entry Fields" wizard page, note that the Vendor table is also listed, not just Invt. This is because it is a parent table of Invt. Add the following columns:

  8. Invt.Item_Id
  9. Invt.Description
  10. Vendor.Id
  11. Vendor.Name
  12. Invt.Vendor_Part_Id
  13. Invt.Unit_Price
  14. Invt.On_Hand

Click Next.

  1. On the Index wizard page, leave the default selection of Create index combo - design time control selected and click Next.

  2. On the "Selection Fields" wizard page, do not add any columns and click Next.

  3. On the "Records per Page / Drill Down Report" wizard page, enter 10 as the number of records per page and click Next.

  4. On the "Drill Down" wizard page, select Invt.Item_Id from the combo form.

  5. Click on the Use existing ASP file for the zoom, entry or report radio button and type InventoryEntry.asp into the file name form.

  6. Click Next.

  7. On the "Style sheet options" wizard page, simply accept the default Cascading Style Sheet (CSS) and click Next.

  8. Click Finish on the last wizard page.

You should now be back in the Studio, with the outline of the newly created InventoryItems.wo and InventoryItems.asp pages open in the Code Editor.

Testing the Report

  1. Click on the Run button on the Studio's toolbar. The Studio will compile, then run your project. When the application runs, your browser should display the testcontent.htm page.

  2. Click on the Inventory Items Listing link.

  3. Click on the Run Report button.

  4. Close your browser to return to the Studio.

Next Step

List Customers Drill Down Report