0

report not displaying in order date order

Jet Reports Historic Posts

July 30, 2013 19:34

None

Follow

Hi-

Attached is a report I built to show the number of days it takes to ship an order.

Calculations are fine but when the report is run it's not displaying the order dates in chronological order.

I.e. The report shows data for 1/3/13, then 1/2/13 and then 1/4/13. 1/8/13, 1/7/13 and then 1/9/13.

I would like to be able to print the report so that the data is displayed in order by order date.

Any help would be appreciated…

Report attached..

Thanks! Jen

• order date vs ship date metrics report.xlsx

• Facebook
• Twitter
• LinkedIn

3 comments

• 
  Jet Reports Historic Posts July 31, 2013 06:42 Official comment

  Hi ,
  you start with
  =NL("Rows=4";"Sales Invoice Header";"Order Date";"Order Date";$C$2;"+Posting Date";$C$3;"Salesperson Code";$C$4;"Bill-to Customer No.";$C$5)
  
  so its sorted by posting date
  so try this, maybe its that, what you want…:
  
  =NL("Rows=4";"Sales Invoice Header";"Order Date";"+Order Date";$C$2;"Posting Date";$C$3;"Salesperson Code";$C$4;"Bill-to Customer No.";$C$5)

• 0
  
  Jet Reports Historic Posts August 01, 2013 13:27

  Thank you! That worked…the report now lists in chronological order by order date.

• 0
  
  Jet Reports Historic Posts August 02, 2013 07:33

  ;) great