Export Data

Horse06

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!!

mohana_cse06

The information is not sufficient..
is it a dataport or report? how you have programmed the logic? is it the first field?

Administrator

[Topic moved from 'NAV Tips & Tricks' to 'NAV/Navision Classic Client' forum]

Horse06

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!