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 :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Report not printing mu...
Microsoft Dynamics NAV (Archived)

Report not printing multiple lines

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I'm trying to create a report about a Fixed Asset and I want to print all the purchase orders associated with this Fixed asset. At the moment, only 1 purchase order is being shown, not all of them.

Any ideas?

Capture21.PNG

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 61,214 Super User 2026 Season 1 on at

    what is the link between Purchase line and Fixed Asset?

    Did you add purchase line fields in right body section in rdlc layout?

  • Community Member Profile Picture
    Community Member on at

    The links are:

    DataItemTable - Purchase Line

    DataItemTableView - WHERE(Type=CONST(Fixed Asset))

    DataItemLinkReference - Fixed Asset

    DataItemLink - No.=FIELD(No.)

    This is my layout:

    Fixed Asset No Invoiced PO No Invoiced PO Line No Invoiced Description Invoiced Quantity Invoiced Amount
    [FixedAssetNo] [InvoicedPO_No] [InvoicedPO_Line_No [InvoicedDescription [InvoicedQuantity] [InvoicedAmount]
  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 61,214 Super User 2026 Season 1 on at

    this should be in body section. did you check that?

    [FixedAssetNo] [InvoicedPO_No] [InvoicedPO_Line_No [InvoicedDescription [InvoicedQuantity] [InvoicedAmount]

  • Community Member Profile Picture
    Community Member on at

    Yeah it is. Every thing seems correct I'm not sure why it's not working.

  • Community Member Profile Picture
    Community Member on at

    Hi,

    I have a report with multiple data items. However, only the first data item is working. The second data item is not retrieving any values. Any ideas?

    Thanks!

    3247.Capture2.PNG

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 61,214 Super User 2026 Season 1 on at

    please add a message like Message('%1',"Purchase Line"."No."); in Purchase Line dataitem onAftergetrecord trigger and see whether you are getting records or not?

  • Community Member Profile Picture
    Community Member on at

    I can see on the 'About This Report' page that the records are being retrieved

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 61,214 Super User 2026 Season 1 on at

    then its issue in layout.

    please share your layout

  • Nitesh bhoir Profile Picture
    Nitesh bhoir 72 on at

    Hi Mohana,

    I am facing same problem,but when i have added message to see list line No then its showing only one purchase  invoice No.can you suggest for the same

  • Suggested answer
    divyeshchitte Profile Picture
    divyeshchitte 970 on at

    Can you Share your Code, Layout and About this Report section.

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
TAHER_El_Mehdi Profile Picture

TAHER_El_Mehdi 2

#1
sliderxb Profile Picture

sliderxb 2

#1
broberts Profile Picture

broberts 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans