Simple Query based Report

(0) Share

Report

Posted on by startax

1,845

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.

This is just an example of my query looks like this image.

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

SunilRakesh 340 on at

Like (0)

Report

Try to put datasource CustTable and relate with ProjInvoiceJour with OrderAccount/AccountNum and select your fields on report. Hope it works.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi,

You can utilise display method

Was this reply helpful? Yes No