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