Export Data

Horse06
Horse06 Member Posts: 496
edited 2011-03-03 in NAV/Navision Classic Client
Hi Expert, I need your help! I have created a program to export the data, but I have little trouble here. Every time, only one particular field in the first line is missing and the rest of them are fine. How to fix it? Appreciate it!!

Comments

  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    The information is not sufficient..
    is it a dataport or report? how you have programmed the logic? is it the first field?

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • Administrator
    Administrator Member, Moderator, Administrator Posts: 2,506
    [Topic moved from 'NAV Tips & Tricks' to 'NAV/Navision Classic Client' forum]
  • Horse06
    Horse06 Member Posts: 496
    This is using report export. This is based on the sales header and tracking dataport.

    I want to export one data (varchar) from the trackging table, but if the code is added to the tracking onafterrecord, it is fine, but data always goes down to the next line after the export. If the code is added to the sales header onafterrecord, this time the the data are wrong and some are empty and some grab the data from the first field.
    Please advise!

    How to use the if condition? If the data is null, fill the field with None, else pull the orginal data. Mine does not work.


    if Trackink."Tracking Number" ='' then
    trackingnumber :='none'
    else
    trackingnumber := Tracking."Tracking Number";


    Appreciate it!

Categories