Windows Forms RDLC Page Totals In Page Footer

Windows Forms RDLC Page Totals In Page Footer

Windows Forms RDLC Page Totals In Page Footer

I'm trying to put page totals on a Windows Form 2008 RDLC report using

CODE

=SUM(Fields!buyprice.Value)

for the textbox, but I get the following error.
"The Value expression for the textbox ‘textbox17’ refers to a field. Fields cannot be used in page headers or footers."
Is there anyway around this? I want the totals for each page, not a running total.

On another note, why did they make these reports so that you can't use the fields in the page header or footer without resorting to using Report Items? Am I going to have to use some sort of code to sum these?

RE: Windows Forms RDLC Page Totals In Page Footer

Yes that does work, thanks. I was going down that path when I saw your post. The only problem I have is that I used

CODE

=IIF(Fields!buyprice.Value = 0, "-", Fields!buyprice.Value)

for some of the fields to print a Dash instead of zero. I made a separate detail row to hold just the field names, but you cannot hide the row because then the report items don't work and you can only set the row height to a minimum of 0.03125in and make the individual cells hidden. That's not bad but does add space between the visible detail rows. Is there a way to format zero values as a Dash? I also cannot figure out how to get a record count per page.

Late Update: I figured out how to do the Dashes. I can set the Format to