Oracle Reports 2.0

From: Santosh Gandhari <santosh_at_ims.com>
Date: 1995/06/07
Message-ID: <3r5bro$96v_at_phoenix.ims.com>#1/1

I am trying to customize a report using Oracle reports 2.0 and have a question to all the users. If you could please send me any information on this, I would greatly appriciate it.

What I trying to do is select items, cost, value from a subinventory location MRB1 and group by the locator (AN10133, BN27874, VZX37373) which is mil.segment1. I am getting the error not a group by expression. What I have to do is to group by the locator but only use the first two or three charaters of the Locator.. like AZ2334 group by 'AZ'. I tried using rtrim and group by expression together but it didn't work.  

The code .......

select &P_item_flex Item,

   moh.transaction_quantity      Qty_In,
   cic.item_cost          Cost,

  ((moh.transaction_quantity) * (cic.item_cost)) Std_Value,    mil.last_update_date Last_Tx,
 round(to_char(SYSDATE - mil.last_update_date)) Days_In,    &P_loc_flex Lot_No
from

mtl_system_items  msi,
mtl_item_locations mil,
cst_item_costs   cic,
mtl_onhand_quantities   moh,
mtl_secondary_inventories si

where si.secondary_inventory_name = moh.subinventory_code (+) and si.organization_id = moh.organization_id (+)

and moh.organization_id = msi.organization_id (+)
and moh.inventory_item_id = msi.inventory_item_id (+)
and moh.locator_id = mil.inventory_location_id(+)
and moh.organization_id = mil.organization_id(+)
and msi.inventory_item_id = cic.inventory_item_id(+)
and msi.organization_id = cic.organization_id(+)

and si.secondary_inventory_name = 'ZMRB1' GROUP BY mil.segment1
order by &P_loc_flex

Thanks..

santosh. Received on Wed Jun 07 1995 - 00:00:00 CEST