Simple Query based Report

Hi ,

I need to build a report that have 5 fields from custtable and also have ( ContactPersonName ) Field that comes from different table I tried to make query and set relation and join ( Inner join ) but when i generate report ( ContactPersonName ) is Blank Do i have to write some method or any code in query or Visual Studio plz suggest me .

Thanks in advance.

Write a display() for that method and drag and drop it in your design wherever you wish it to display and also don’t forget to put label from the property tab in the end.

Please mention your AX version. The way the reports are handled in AX 2012 is different from the previous versions.

I hope you are asking about AX 2012, look at the CustBaseData report.