Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Sum of multiple Report footer fields

Posted on by 120

Hello everybody,

I currently have the task to create a Report for my company, which will be executed from CRM. So far the development ran pretty smooth and I now have everything I need exept one "simple" thing which gives my the headaches.

I have multiple Textboxes in the footer which are holding different € values which I get from various expressions ( basically SUM(ReportItems!<Fieldname>.Value)). Now I want the sum of all these Fields. So my approach was to just do something like ReportItems!<Name of Textbox>.Value) + ReportItems!<Name of Textbox>.Value) + ReportItems!<Name of Textbox>.Value) etc. but I get the error message "The Value expression for the textrun ‘Textbox57.Paragraphs[0].TextRuns[0]’ refers to more than one report item. An expression in a page header or footer can refer to only one report item.".

I googled several days but everywhere it says that this is only possible with the use of code, but the problem is that I am developing for CRM Online so no code is allowed in the reports because of the damn Sandboxing thing.

Did anyone of you ever had a similar problem and could help me? I am freaking out right now because this is the last field that needs to be filled before everything would be perfect.

Thanks in advance! 

Greetings from Germany.

*This post is locked for comments

  • mohammed.mqi Profile Picture
    mohammed.mqi 2,016 on at
    RE: Sum of multiple Report footer fields

    i have same issue any solution  do you fined?

  • wizz raka Profile Picture
    wizz raka 15 on at

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans