I have merged 2 queries
· Delivery num
· Delivery Item
· Sales order
· Sales Item
I merged Reference number and Sales Oder number, after merging I was getting incompatible object error while trying to add Delivery Num and Delivery Item to report layout, so I created a variable and made it detail =[ Delivery Num]and associated it with merged dimension and same as detail=[ Delivery Item]
It worked fine for Delivery Number. But a Delivery number may contain many Delivery item,(1:N relationship) and Delivery item is not getting segregated. Hence I am getting #MULTIVALUE ERROR
I have gone thru many formus and no where there is a solution to this.
Does anyone know alternate method to add incompatible object to report after merging, instead of converting it to detail?
Thanks in advance