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

Notifications

Announcements

Community site session details

Community site session details

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

Modifying RDCL Custom Report Layout

(0) ShareShare
ReportReport
Posted on by 4

Hello,

I'm currently trying to modify a custom report layout (RDLC). The specific report is Inventory Movement report. My problem is that I want to add a field which isn't an available field to the report via Microsoft report builder. I can add new fields but when I import it back to business central, I get the below message. 

"Rendering output for the report failed and the following error occurred: The Value expression for the text box 'DocumentNoFieldCaption' refers to the field
DocumentNoFieldCaption'. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Letters in the names of fields must use the correct case".
How do I resolve this?  Thanks
Warm regards
Bryma
I have the same question (0)
  • Hein Kruger Profile Picture
    629 on at

    Hi Bryma, 
    The correct way would be the create a report extension in AL code and add the field to the correct data item or as a label. Deploy the extension and the new field will be added to the layout assigned to the layout path. 

    if its only a caption change in the text box you can use '="New Caption" ' or 'New Caption' (do not include the single quotation marks.)
    pastedimage1679508313739v1.png
    pastedimage1679508331108v2.png

  • Suggested answer
    YUN ZHU Profile Picture
    96,256 Super User 2025 Season 2 on at

    Hi, just adding a simple example, hope this helps as well.

    https://yzhums.com/10723/

    Thanks.

    ZHU

  • Bryma Profile Picture
    4 on at

    Thanks

  • Bryma Profile Picture
    4 on at

    Thank you so much

  • Suggested answer
    Bryma Profile Picture
    4 on at

    I have been able to build the report from the AL environment using VS code.  

    Thanks everyone

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

News and Announcements

Season of Giving Solutions is Here!

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 1,703

#2
YUN ZHU Profile Picture

YUN ZHU 803 Super User 2025 Season 2

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 750 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans