top of page
Writer's pictureNosh

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.

50 views0 comments

Recent Posts

See All

Comments


bottom of page