Linking tables in a dataport

meemz

hi there
I am exporting orders from sales header (36) and sales line(37) to csv.
I have managed to filter the sales headers to just the order no.s i need but i keep getting the entire sales line table!

I tried to create an array to store the order no.s here -

Sales Header - OnBeforeExportRecord()
SalesHeaderArr:="No.";

Then tried this in the sales line -

Sales Line - OnBeforeExportRecord()
j += 1;
SETRANGE("Document No.",SalesHeaderArr[j]);

-help? :-k

HalMdy

To link two tables in a Dataport, as in a report :

- Increment Right the "Sales Line"
- In the properties of the "Sales Line" , fill in DatatemLink

And then you take only Sales lines from the Header ...

Hope I have understood your problem and clarified it as well

meemz

I did try that but if you indent anything in a dataport then it says you have to change the file format to UPXML ??
I want to be able to see what i have exported thats why i was trying to export to csv.

Albertvh

Hi Meemz

on your salesline dataitem on the the predataitem insert the following code

COPYFILTER(Salesheader."No.");

Hope this sorts you out.

Cheers

Albert

meemz

Nice one bruvva!
Worked like a dream!
thanks!
:P