Data Modeling with the Table Area Option
Updated: Sep 3, 2022
The table option under the Area dropdown gives you the ability to create your own data model by selecting any table in Business Central. Here we will walk through creating a basic report using the Table option. Let's get started.
Click New to create a new report and give it a name.
Click Area and select Table.
Click Design in the action menu ( a new window opens).
Click Table 1 in the first column (a popup window will open).
Click in the Table Name field and select "Sales Header". Close the window.
Click Date Filter Field and select the "Order Date" field from the lookup.
Click Close to return to the previous window.
Click Table 2 in the first column
Click Table Name and select "Sales Line".
Close the window
Now that we have the tables selected for our report, we will select the fields.
Click Column A in the Sales Header row and select Name
Click Column B in the Sales Header row and select No.
Click Column B in the Sales Line row and select No.
Click Column C in the Sales Line row and select Document No.
Click Column D in the Sales Line row and select Amount Including Tax
Click Filters in the menu
Click Document Type for Sales Header an select Order
Click Document Type for Sales Line and select Order
Click OK to close the window
Now run the report to see your results. Remember to set filter in the order date field.