running value are not printing in page footer in Sql server reporting Services 2005

See more:

reporting-services

Hi everybody,

I've created one SSRS in that I've connected to the database having four fields.

Now what I want is to calculate the salary page by page and at the last the grand total.

I've kept one extra column in table and kept one running field and made it as hidden. I've taken one textbox and placed in page footer with the expression="PAGE RECORD TOTAL="& Last(reportitems("Subtotal1").Value)

Where subtotal1 is a running field and I'm taking the last value of that and printing in page footer.

Now my problem is that when I run the report the value will be present but when I click on preview or take the print the value has disappeared.

And when I make the running field hidden=false then it will display while printing as well.

I don't want to show the running field I want to hide it.

I've created the report with the following link:

http://community.dynamics.com/blogs/navteam/archive/2010/03/17/transfooter-and-transheader-functionality-in-rdlc-40-ssrs-41-reports.aspx[^]

Please help me