Creating a Report with Line Items

You can use the Table Wizard to create a report with all the Line Items.

Using Invoice as an example, the following explains how to create a report with Line Items:

  1. Add a blank line after for-eachINV_RECORD_NO - INV_TITLE operator and leave your cursor.
  2. Select Table Wizard on the Oracle Analytics Publisher Ribbon.
  3. Select Table as your Report Format, and select Next.
  4. Select /DATA_DS/Inv/LineItem as your Data Set (or the name that you had given your Line Item data set).
  5. Select the fields that you want to add to the table. Because this is for the Invoice line items, you must only add fields that are specific to the line items.

    If you must add a field for "group on" (for example, Inv_Li_Record_No), the grouping process is similar to the process explained in the preceding section. Because you have grouped the records by Invoice in the preceding section, you can leave the value blank.

    The order of the selected columns must match the order that you want in your table, except for the column that you use for grouping, which is outside the table. In the "Which fields do you want to show in your report" window, match the order as shown here:

    Inv Li Record No --> In Li Record

    Inv Li No --> Inv Li No

    Inv Li Desc --> Inv Li Desc

    Inv Li Unit Price --> Inv Li Unit Price

    Inv Li Quality --> Inv Li Quality

    Inv Li Amount --> Inv Li Amount

    Inv Li Uom --> Li Uom

    Code --> CodeInv

    Item --> Item

  6. In the "How would you like to group your report" window, leave every option as is because you have already grouped your data by Invoice in the preceding section.
  7. In the "Which fields would you like the user to sort the data" window, within each table, sort the lines by Inv_Li_No (Invoice Line Item Number). Specify that this is a Number so that it is sorted correctly.
  8. Select Finish.

The Table Wizard inserts the table and the necessary code:

for-eachINV_RECORD_No - INV_TITLE

Inv Li No Inv Li Desc Code Item Inv Li Quantity Inv Li Uom Inv Li Unit Price Inv Li Amount
F INV_LI_NO INV_LI_DE SC CODE ITEM INV_LI_QUANTITY INV_LI_UOM INV_LI_UNIT_PRICE INV_LI_AMOUNT E

page breakend

You must run the report to see what information is generated. While the data is correct, you must work on formatting the data. See Formatting Data.