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

Manufacturing Comment Lines not displaying in my report

(4) ShareShare
ReportReport
Posted on by 18
Dear Community,
 
I created a report extension for Production Order. I would like to display the comments in the Prod BOM Header.
 
For this, I created the following dataset:
 
reportextension 50010 VERINTProdOrderComp extends "Prod. Order - Mat. Requisition"
{
    dataset
    {
        add("Production Order")
        {
            column(EndingDateTime; "Ending Date-Time") { }
            column(StartingDateTime; "Starting Date-Time") { }
        }

        addlast("Production Order")
        {
            dataitem("Prod. BOM Comment"; "Manufacturing Comment Line")
            {
                DataItemLink = "No." = FIELD("Source No.");
                DataItemTableView = WHERE("Table Name" = FILTER("Production BOM Header"));
                column(MCL_Comments; Comment) { }
            }
        }

    }
}
 
Then, on my report, I added the field [MCL_Comments], but it remains empty despite I have 6 lines of comments in my table:
 
 
Could you please guide me to the solution?
 
Best regards,
Jay Rome
 
I have the same question (0)
  • Sagar Dangar, MCP Profile Picture
    799 Moderator on at
    Hi,
     
    Try below code in AL and make sure "MCL_comment" Column in RDLC layout should be under "details" groups.
    addlast("Production Order")
            {
                dataitem("Prod. BOM Comment"; "Manufacturing Comment Line")
                {
    
     DataItemLinkReference = "Production Order";                
    DataItemLink = "No." = FIELD("Source No.");
                    DataItemTableView = WHERE("Table Name" = FILTER("Production BOM Header"));
                    column(MCL_Comments; Comment) { }
                }
            }
     
  • Raj Borad Profile Picture
    1,560 on at
    Hi,
     
    Along with the suggested approach/code by Sagar, also make sure the below things:

    - The "Production BOM No." field is available in DataSource ("Production Order") table.
    - Comments exist in the DataSource ("Manufacturing Comment Line") table for that Production BOM No.
     
    Thanks.
  • JR-26030758-0 Profile Picture
    18 on at
    Hi Sagar,
     
    Your message was very helpfull. The solution was here: I did not create a "detail" group. Now, the lines are successfully displayed.
     
    Thank you :)
     
    Jay Rome
  • Suggested answer
    DAnny3211 Profile Picture
    11,417 Super User 2026 Season 1 on at
     

    Hi there,

    Your approach is close, but the issue likely lies in the DataItemLink and DataItemTableView configuration. Here are a few things to check and adjust:

    1. Verify the Link Between Production Order and Manufacturing Comment Line

    • The DataItemLink = "No." = FIELD("Source No.") assumes that "Source No." in "Manufacturing Comment Line" matches the "No." of the "Production Order".
    • Confirm that this relationship is valid in your data. If not, you may need to adjust the link to match the correct field.

    2. Check the Table Name Filter

    • Your DataItemTableView uses:
     
     

    WHERE("Table Name" = FILTER("Production BOM Header"))

    • Ensure that the value "Production BOM Header" exactly matches the value stored in the "Table Name" field of the "Manufacturing Comment Line" table. It must be case-sensitive and match the internal enum or string value.

    3. Use Debugging or Temporary Output

    • Add a temporary column to output "Table Name" and "Source No." to verify that the filtering is working as expected.

    4. Consider Using a Join via AL Codeunit

    • If the dataset structure is too restrictive, consider using a codeunit to fetch and format the comments, then expose them via a temporary table or variable.

    Let me know if you'd like help rewriting the dataset or validating the data relationships!

    Please verify if this response was helpful.

    Best regards!

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,804 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,103 Super User 2026 Season 1

#3
Kamal Khakhkhar Profile Picture

Kamal Khakhkhar 695

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans