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 Go to next message
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
Re: REP-1259: Group 'G_CF_ORDER_NUM_LOW' has no break columns [message #500229 is a reply to message #500227] Fri, 18 March 2011 06:51 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In Data Model layout editor, go to "G_CF_ORDER_NUM_LOW". Open "SUBINVENTORY" column's property palette window and change its break property from "None" to "Ascending".
Previous Topic: anchoring object.
Next Topic: Ageing Report
Goto Forum:
  


Current Time: Thu Mar 28 08:23:22 CDT 2024