export 2 tables with one dataport to an CSV file

Renko

I have two tables and need information out both the tables.

the export file on this moment looks like this:

1,DB,Dick Beekman //this is table <CourseRegistrationHeader>
2,JR,Johan Rienks

Van Terp Kantoorinrichting,1 //this is table <CourseRegistrationLine>
Anton Geestig Adviezen,1
Koopmans Verzekeringen B.V.,1
Sound&Vision,2
Candoxy Canada Inc.,2

the layout i like to see is like this:

Van Terp Kantoorinrichting,1,DB,Dick Beekman
Anton Geestig Adviezen,1,DB,Dick Beekman
Koopmans Verzekeringen B.V.,1,DB,Dick Beekman
Sound&Vision,2,JR,Johan Rienks
Candoxy Canada Inc.,2,JR,Johan Rienks

table <CourseRegistrationHeader> has the following fields:

Enabled SourceExpr StartPos Width
Yes "No." 1 10
Yes TrainerCode 12 10
Yes "Trainer Name" 23 30

table <CourseRegistrationLine> has the following fields:

Enabled SourceExpr StartPos Width
Yes Name 12 30
Yes No 1 10


where "No." and No must be linked or something.


thanks in advance!

kine

Still, you can use Integer table for your dataitem and export just variables. You just needs to fill the variables with the values through C/AL code from both tables and you are done... :-) Without C/AL it is not possible...

Renko

Can you give me an example of the C/AL code? I'm a newbie with all of this. I thought it would be possible with just 1 line of code :P