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

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Total values not pulling through to RDLC report

(0) ShareShare
ReportReport
Posted on by 129

This is an issue I've had with both a Purchase Order and a Sales Quote Layout.

The majority of fields are working but I can't seem to pull through any data for any of the totals.  I've even added all of the 'Total' fields to a text box to see whether I've just used the wrong field but it has returned a blank.

Here is a screenshot of the RDLC file:

pastedimage1616069754166v1.png

But then when I import it into BC and run a report, this is all I'm getting:

pastedimage1616069781414v2.png

So as you can see, the TotalNetAmount, TotalVATAmount and TotalAmountInclVAT fields in the table aren't returning any data, neither are all the fields I'd added to the textbox to the left.

Can anybody shed any light on why this may be?

I have the same question (0)
  • AI123456789 Profile Picture
    129 on at

    To clarify, there is data in these fields in Business Central.  It works when I run a report using a standard Word layout

  • Suggested answer
    Andy Sather Profile Picture
    on at

    If I had to guess they need to reference the standard reports and how the totals are created using the Code.GetData that references the "FooterInfor" text box held in the body/matrix and has the "create string" data.  Then that can be used in the footer of the report and not the main table

  • Suggested answer
    JAngle Profile Picture
    133 on at

    For more info on using the required getdata and setdata methods of RDLC, check this thread: community.dynamics.com/.../setdata-and-getdata-on-nav-reporting-layout

  • Brian Marks Profile Picture
    5 on at

    Did you find an answer to this? I am having the same issue.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,135

#2
YUN ZHU Profile Picture

YUN ZHU 733 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 612

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans