Dynamics Community Forum Thread Details

Not printing properly after create relationship with table

Hi,

Please find below screen-shot of delivery note by using GP report writer, it prints delivery note details. It print all the line items of sales invoice line items from main table AFT_DO_Report_PERM. Report is working perfectly up to this point. No issue.

I added one more table called AFTSERNO which holds data of corresponding serial numbers of line items. I want to print these serial numbers also at bottom of each line items. So I created a table relationship with main table as show below screen-shots. But once I created relationship with main table, reports print only the line items with serial numbers. So its look like when create table relationship, it create INNER JOIN between tables, so reports contain only if records of two table are matching. Please find screen-shot of second report with serial numbers. This reports does not print line items XL510AV and 226-25 since there is no serial numbers on these line items.

I added additional header and move the line items on this header and print serial number put on body of the report.

Kindly help me how to solve this issue, we need line items without serial numbers also on this report