What is the best way to print columns from different tables on the same row using the Axapta reporting tool?

Question

It seems that each section of the body in an axapta report can only print columns from a single table (sequentially). For example: I have a report that has the following tables: SalesLine, InventTable and CustTable. Then I would like to print columns from each of these tables on the same row. It seems that I can do this by placing fields in programmable sections, but not when I put them in body sections.

I found some workarounds that are either ugly or inefficient. Should there be a good clean way to do this?

Answer 1

, , . SalesContractShipment 4.0 .

SalesLine InventTable CustTable. InventTable CustTable , FetchMode 1:1. , , send() . CustTable, InventTable, SalesLine . SalesLine. .

, . - . - SalesLine displayMethods , , InventTable CustTable.

Answer 2

, , . " " → "" "AnyTableThatIsADataSource". , , .

Answer 3

Put all the fields in the last SourceTable_Body, and it will display all the fields, because the QueryRun table is on the table and will fill the body with each corresponding Body, so the last body will have all the field data.

Answer 4

Consider using temporary tables. Fill it with your data first than use in the report.