Hello Baan gurus, please could you help and advice ?
I am trying to use two different reports and join them into 1.
The report1 is for some transaction related to standard items - so here I am using table "tdinv150"
The report2 is for some transaction related to customized items - so here I am
using table "tipcs500"

I would like to have just one report what consist of data from both reports.

is this possible in Baan Easy SQL ??

Hi

Do you want 1 record from one table and then second record from other table ?

Are the Headings of the Report remain the same ?

You can involve a temporary table and put data into that table every time prior to printing the report and then print the data from that table ...

Hello
I would like to only have 1 report at the end.
The headings are almost the same, except last one (delivery date), where I also look for the date. But I might have report looking like:

header 1 (......... last column stands for field tdinv150.date)
data 1

header 2 (......... last column stands for field tipcs500.date)
data 2


regards
Tomas