Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Error in Report

Posted on by 3,027

Hi

 

  I am displaying this value in Footer  Sum(Fields!SalesLineExciseAmt.Value)

 

Error while validating RDL content.

The value expression for the Textbox textbox10 references a field in aggregate expression without a scope. A scope is required for all aggregates in the page header or footer which references fields.

Thanks

*This post is locked for comments

  • Verified answer
    Tina Menezes Profile Picture
    Tina Menezes 2,576 on at
    RE: Error in Report

    Hi,

    Yes you will get this error. So to solve this, you have to fetch this field i.e. SalesLineExciseAmt.Value in a textbox in your report body. Hide this textbox as you do not want it to be displayed in the report. Now in your Footer where you want to display this value, put the following expression: ReportItems!<TextboxName>.Value where TextboxName should be the name of the textbox which has the field value in your report body.

  • Verified answer
    Marcellus Profile Picture
    Marcellus 2,735 on at
    RE: Error in Report

    Hi Jsshivalik,

    Try it like this: Sum(Fields!SalesLineExciseAmt.Value, "DataSet_Result")

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans