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

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Sum of multiple Report footer fields

(0) ShareShare
ReportReport
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

I have the same question (0)
  • mohammed.mqi Profile Picture
    2,050 on at
    RE: Sum of multiple Report footer fields

    i have same issue any solution  do you fined?

  • wizz raka Profile Picture
    15 on at
    RE: Sum of multiple Report footer fields

    http://chickenpox.me/

    http://billofsale.info

    periodictableofelements.net

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…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
Christoph Pock Profile Picture

Christoph Pock 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans