Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Unable to unable to ru...
Small and medium business | Business Central, N...
Suggested answer

Unable to unable to run report

(0) ShareShare
ReportReport
Posted on by Bryma 4

Hello everyone,

I am currently unable to run a report after building it from the AL environment. The report is 7321 - Inventory Movement (RDLC). The reason for building the report was to add Document No field which wasn't in the source code. The report was published successfully, and I could run it on the built ID: 50102. However, when I import this into the custom base application for 7321 (not the built-in), I get a textbox error message for the modified field.

Find below attached screenshot for error message. 

Thank you so much 

Bryma

Screenshot_5F00_20230404_2D00_111409_5F00_Microsoft-365-_2800_Office_2900_.jpg

  • Suggested answer
    Shathika Karunaratne Profile Picture
    Shathika Karunaratne on at
    RE: Unable to unable to run report

    First of all, you do not need to create a new report for this. instead, you can create a report extension where you will be able to extend a standard report and you can add your document no field there.

    In here the error is coming because "DocumentNoFieldCaption" field is not in the dataset. you might create it as a Label or text constant. But you need to put it under the main data item set. then you will be able to overcome from this aforementioned error

    pastedimage1680842757913v1.png

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 75,942 Super User 2024 Season 2 on at
    RE: Unable to unable to run report

    Hi, If you're just adding a field, I don't see the need to create a new report, you can do it with the Report Extension. The reason for this error should be that you did not add this field in the 7321 report.

    More details: https://yzhums.com/10723/

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Bryma Profile Picture
    Bryma 4 on at
    RE: Unable to unable to run report

    I was able to write a code using Code unit to substitute the base application report with the built one so that the system recognizes the built report.

  • Suggested answer
    Hasnain Ali Profile Picture
    Hasnain Ali 132 on at
    RE: Unable to unable to run report

    Hi,

    column "DocumentNoFieldCaption" may be removed or renamed from/in the dataset.

    Try creating this column in the dataset and run the report again.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,784 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,476 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans