Calling Flowfield values.

aliennavaliennav Member Posts: 449
Hi All
I have created a flowfield (LOOKUP) on a customer card in which opens a form showing only those records which contains that customer no. in them.

Now I want to display those records on a report.
Pl. suggest a way.

Comments

  • garakgarak Member Posts: 3,263
    u can use the command:
    MyDataItem.Calcfields(MyFlowField);
    

    or the property "CalcFields" on the DataItem.

    Regards
    Do you make it right, it works too!
  • aliennavaliennav Member Posts: 449
    garak wrote:
    u can use the command:
    MyDataItem.Calcfields(MyFlowField);
    

    or the property "CalcFields" on the DataItem.

    Regards

    Thanx, BUT I dont want the consolidated value, I want all the values for that cutomer.(May be directly from the table.
  • DaveTDaveT Member Posts: 1,039
    Hi,

    Then it's your report design you need to modify e.g. if the flowfield is a lookup on the Cust. Ledger Entry then structure your dataitem as

    Customer
    Cust. Ledger Entry

    and set the DataItemLink property
    Dave Treanor

    Dynamics Nav Add-ons
    http://www.simplydynamics.ie/Addons.html
  • DenSterDenSter Member Posts: 8,304
    You shouldn't be using a lookup flowfield if you have more than one record in the related table.
  • devu_13devu_13 Member Posts: 101
    Hi

    you can use this code
    MyDataItem.Calcfields(MyFlowField);
    Devendra Kr. Sharma
    IBIZ Consulting Services,India
Sign In or Register to comment.