Use multiple ReportItems in one expression in RDLC Report

Question

I want to display page wise sum of 2 columns in footer.for that I am using following expression in footer

=Sum(ReportItems!col1.Value) + Sum(ReportItems!col2.Value)

but it gives following error

"The Value expression for the textrun refers to more than one report item. An expression in a page header or footer can refer to only one report item."

anybody knows how can I solve this issue and display page wise sum in footer ?

Thanks

Answer 1

Here is simple workaround for your problem:

1. Add single textbox to the body of the report and name it i.e. "SUM"
2. Add your expression to this textbox =ReportItems!col1.Value + ReportItems!col2.Value
3. For this textbox set visibility as hidden
4. In the footer refer to this hidden textbox using =ReportItems!SUM.Value