Home » Developer & Programmer » Reports & Discoverer » REP-1259: Group 'G_CF_ORDER_NUM_LOW' has no break columns (Report Builder 10.1.2.0.2)
REP-1259: Group 'G_CF_ORDER_NUM_LOW' has no break columns [message #500227] |
Fri, 18 March 2011 06:42 |
kishan_nag
Messages: 19 Registered: June 2005 Location: Mumbai
|
Junior Member |
|
|
I am getting the following error REP-1259: Group 'G_CF_ORDER_NUM_LOW' has no break columns after added order by caluse to the below query in one of the report.
Please help me ,if some knows what's the error?
Thanks in advance.
Regards,
Ramkishan
Query
select sum(wpsv1.primary_qty) detail_qty,
--chr(14)||'*'||sum(wpsv.primary_qty)||'*'||chr(15) detail_qty_barcode, -- Added by Sudheer on 08Sep08 CR7809 Barcode
wpsv1.from_subinventory subinventory,
wdd.revision revision,
wdd.lot_number lot_number,
wpsv1.from_locator_id inventory_location_id,
wdd.delivery_detail_id detail_delivery_detail_id,
-- &C_LOCATION_SELECT location_select,
wdd.inventory_item_id id_inventory_item_id,
wpsv1.line_status
from wsh_pick_slip_v1 wpsv1,
wsh_delivery_details wdd, mtl_item_locations il
where wpsv1.from_locator_id = il.inventory_location_id(+)
and wdd.move_order_line_id = wpsv1.move_order_line_id
group by wdd.delivery_detail_id,
wdd.subinventory,
wpsv1.from_subinventory,
wdd.revision,
wdd.lot_number,
wdd.locator_id,
wpsv1.from_locator_id,
wdd.inventory_item_id,
wpsv1.line_status
-- &C_LOCATION_SELECT
--order by wpsv1.from_subinventory
union
select sum(wpsv2.primary_qty) detail_qty,
--chr(14)||'*'||sum(wpsv.primary_qty)||'*'||chr(15) detail_qty_barcode, -- Added by Sudheer on 08Sep08 CR7809 Barcode
wpsv2.from_subinventory subinventory,
wdd.revision revision,
wdd.lot_number lot_number,
wpsv2.from_locator_id inventory_location_id,
wdd.delivery_detail_id detail_delivery_detail_id,
-- &C_LOCATION_SELECT location_select,
wdd.inventory_item_id id_inventory_item_id,
wpsv2.line_status
from wsh_pick_slip_v2 wpsv2,
wsh_delivery_details wdd, mtl_item_locations il
where wpsv2.from_locator_id = il.inventory_location_id(+)
and wdd.move_order_line_id = wpsv2.move_order_line_id
group by wdd.delivery_detail_id,
wdd.subinventory,
wpsv2.from_subinventory,
wdd.revision,
wdd.lot_number,
wdd.locator_id,
wpsv2.from_locator_id,
wdd.inventory_item_id,
wpsv2.line_status
--&C_LOCATION_SELECT
order by 2
|
|
|
|
Goto Forum:
Current Time: Thu Sep 19 21:53:53 CDT 2024
|