Last post Dec 09, 2019 06:38 AM by Yongqing Yu
Dec 07, 2019 01:36 PM|DMW2200|LINK
i have 3 textbox value in footer of my report
i want make total (sum) for tow of them
so when i try to make total with them give me this error
The Value expression for the textrun ‘.Paragraphs.TextRuns’ refers to more than one report item. An expression in a page header or footer can refer to only one report item.
i used those code for sum but none of them working
i also tried this but even give me error
is there any idea fro solve this problem
Dec 09, 2019 06:38 AM|Yongqing Yu|LINK
According to your description, in the rdlc report, you can't refer to textboxes in an inner group.
The reason is that when the report is rendered (combining layout information with data), there will be multiple instances of the inner groups.
For example, if the outer grouping is by country and the inner grouping is by state, you'll get multiple states for USA. We wouldn't know from which inner group instance you want to get the textbox value.
You can also refer to this : Report
item expressions can only refer to other report items within the same grouping scope or a containing grouping scope.
If allowed, I suggest you create three textbox values that you need to calculate in the body module of the report, and then
create a textbox to directly calculate the sum of these three numbers in the body, and then hide the textbox.
In the footer, create a textbox to directly obtain the value of the hidden textbox.