Home » Developer & Programmer » Reports & Discoverer » MIS QUESTION
MIS QUESTION [message #89697] Mon, 28 June 2004 07:30
gary
Messages: 35
Registered: January 2001
Member
 

One great challenge question of sorting and db.

Here is the following:

1. invoice number, 2. invoice date,3. shipment lot 4. sutomer name/code, 5 sales group, 6. contract no/Lot, 7 item code, 8.Qty shipped, 9. Vessel name /Voy, 10. on board date, 11. FX, 12. Unit Price, 13. Charges/deductions amt, 14. Invoice amount, 15. Export LC no. 16, LC Tendor, 17 Negotiation bank, 18. Bank in date, 19. Bills umber, 20 Due date, 21. Payment date.

AS u can see the sorting for the question

sort by invoice no.=invoice no. +item no.

sort by contract no. =s/o no. +???? + ??? + ????

sort by Sales Group  = sales group +???? + ??? + ????

sort by item code = item code+???? + ??? + ????

sort by bank in date =bank in date+???? + ??? + ????

sort by accepted date/not accepted  = accepted date +???? + ??? + ????

Pls note: beware that accepted date = blank always sort before accepted date note = blank

sort by paid/not paid. = paid day +???? + ??? + ????

 

 

 
Previous Topic: rep-1259, but break order is specified!
Next Topic: Reports based on Object Types
Goto Forum:
  


Current Time: Thu Nov 28 15:52:26 CST 2024