Report view ->"Sql ORDER BY" is not respected in printformat

Description

Sql ORDER BY on report view is not respected on print format even there is no order by column not selected. I think it is good to have this respected and only override when any of print format item is marked as order.

Environment

None

Activity

Deepak Pansheriya 
May 9, 2020 at 4:26 AM

Pull request created https://github.com/idempiere/idempiere/pull/41

For quick testing I suggest below steps.

  1. Open Unallocated Invoice report. It is already sorted by document no

  2. Click customize button and remove sort order

  3. Now this report is not sorted by DocumentNo

  4. Go to report view and look on record named RV_C_Invoice NotAllocated.

  5. Add DocumentNo in Sql ORDER By field

  6. Cache reset and refresh Unallocated invoice report. This time it should be sorted by document number.

Fixed

Details

Assignee

Reporter

Components

Fix versions

Priority

Created April 4, 2017 at 12:13 PM
Updated July 1, 2020 at 7:52 PM
Resolved May 14, 2020 at 5:09 PM