How to match fields in report.

upasanisandip
upasanisandip Member Posts: 405
edited 2006-05-03 in NAV/Navision Classic Client
Hi,

I am new to Nav. I want to create a new report.
Fields r from table no. 32(Item Ledger Entry Table) -
Entry No., Item No. , Description, Item Ledger Entry No. ( from values entry table-5802).

I want records only that r matching in table no. 32 (Field is Entry No.) and Table no. 5802 (Field is Item Ledger Entry No.) .

How to match that fields in report.
Help me.



Thanks,
Sandip

Comments

  • Albertvh
    Albertvh Member Posts: 516
    Hi Sandip
    in the PreDataItem do the following
    ValueEntry.SETCURRENTKEY("Item Ledger Entry No.","Expected Cost","Document No.","Partial Revaluation","Entry Type","Variance Type",Adjustment);

    then in the AfterGetRecord
    ValueEntry.SETRANGE("Item Ledger Entry No.","Entry No.");
IF Not ValueEntry.FIND('-') THEN
   CLEAR(ValueEntry);

    Remember that in the body section you will add a field with properties SourceExpr ValueEntry."Item Ledger Entry No."

    However the "Entry No." of the Item Ledger Entry will be the same as the ValueEntry."Item Ledger Entry No." perhaps you need the "Entry No." of the ValueEntry table :?:
  • upasanisandip
    upasanisandip Member Posts: 405
    Albertvh, thanks again for quick reply.


    Trying u'r code.

Categories