Error when trying to display location column within a 'report designer' report.

Hi ​@JLW01 

Please attach the .rpx report file (Report Designer Screen > File > Save As)

Best Regards,

NNT

​@nhatnghetinh see attached

Hi ​@JLW01 

Your file is still .rps => This file cannot be opened. Go to Report Designer Screen > File > Save As > > and click Save .rpx file

Best Regards,

NNT

​@nhatnghetinh apologies, should have the correct attached now.

Hello ​@JLW01 ,

Please re-check if are there any duplicate relationships available in the report or GI.

​@JLW01 The issue is because you have a line in the Relations near the top which has InventoryItem as the Child table, then 2nd from the bottom there is a line of InventoryItem as the Parent table, then lastly there is a line where it is again the Child table. All relations of one type need to be above (or below) the relations of the other, so to say, since you have InventoryItem as Child table at the top, you need to switch the order of the last two lines so that all Child table relations are above the Parent relation: