REPORT 322

Stivan_dsouza21
Stivan_dsouza21 Member Posts: 218
edited 2012-06-08 in NAV/Navision Classic Client
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

  • Sog
    Sog 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|
  • dans
    dans 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
  • gerrykistler
    gerrykistler 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_dsouza21
    Stivan_dsouza21 Member Posts: 218
    Thanks Dans and Gerry.

    Its working.......
    Thanks & Regards,
    Stivan D'souza

Categories