web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Report - how to pass two tables as dataitems?

(0) ShareShare
ReportReport
Posted on by 104

Hi. I create report that need to based on two tables as two dataitems. For example:

dataitem(SalesHeader; "Sales Header")

{

some column elements

dataitem(SalesLine; "Sales Line")

{

some SalesLine column elements

}

}

I run this report by pass Sales Header as .SetTableView of report. But I also need to pass Sales Line to this report to show only specific lines related to this Sales Header. How can I set table view also for second dataitem (Sales Line in this example?)

(SalesHEader/SalesLine is only example of report - I have more complicated example and I need to filter exacly two dataitems when Report run)

I have the same question (0)
  • Suggested answer
    Amit Profile Picture
    2,561 on at

    Hi,

    Refer this link for above requirement.

    https://erpconsultors.com/sales-invoice-report-format-and-development/

    Regards

    Amit Sharma

    www.erpconsultors.com

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,821 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,122 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 959 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans