REPORT 322

Stivan_dsouza21Stivan_dsouza21 Member Posts: 218
REPORT 322 - want to sort the report Document date wise.

I have sort the Vendor Ledger Entry dataitem - DataItemTableView property as SORTING(Vendor No.,Document Date,Currency Code)

But then too its not sorting as per Document date wise.
Thanks & Regards,
Stivan D'souza

Comments

  • SogSog Member Posts: 1,023
    If a required sorting is not available, an extra key might be added on the table.
    Or you can create a temporary table and insert records in that table with the entry number modified so it holds your sorting. (A bit more difficult)
    |Pressing F1 is so much faster than opening your browser|
    |To-Increase|
  • dansdans Member Posts: 148
    If I'm not mistaken, that report uses a temporary record variable to show the data. you need to do setcurrentkey to the temporary record instead of data item.
    Microsoft Certified IT Professional for Microsoft Dynamics NAV

    Just a happy frood who knows where his towel is
  • gerrykistlergerrykistler Member Posts: 149
    Dans is correct. The printing is done in the Integer DataItem TempVendortLedgEntryLoop. So in the OnPreDataItem section for this data item set your desired key on the TempVendorLedgEntry variable.
    Gerry Kistler
    KCP Consultores
  • Stivan_dsouza21Stivan_dsouza21 Member Posts: 218
    Thanks Dans and Gerry.

    Its working.......
    Thanks & Regards,
    Stivan D'souza
Sign In or Register to comment.