Hi AX world,
I created a MorphX report in AX2012 which I need two dataSources. The parent DS is ProjInvoiceJour and it has a child DS, ProjInvoiceItem. I set the child relations to field that will link the two table. But the problem, when I ran the report the ProjInvoiceItem is empty. The datasources node looks like this:
I tried to put below lines of codes in the fetch method, and the ProjInvoiceItem holds the correct record. (The field in where clause is the same fields I have in relations)
where projInvoiceItem.ProjInvoiceId == ProjInvoiceJour.ProjInvoiceId
&& projInvoiceItem.InvoiceDate == ProjInvoiceJour.InvoiceDate;
I believe that I dont need to have the above codes in the fetch method, cause the query in DS will perform it. But it is really weird why I still need to initialize the projInvoiceItem.
Any thoughts will be a big help. Thanks!