Hi everybody.. i've created one SSRS in that i've connected to the database having four fields.. now want i want is to calculate the salary page by page and at the last 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 when i run the report the value will be present but when i click on preview or take the print the value will be disappeared.. please help me.. And when i make the running field hidden=false then it will display while printing also.. i dont 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

Hi, I have reproduced the scenario you posted. If the RunningValue column is hidden, the Page Footer would not get the last RunningValue in printing. The simplest workaround is to specify the Color property to White (or the background color in your report) as fake hidden column rather than set the Hidden property. Then the Textbox in Page Footer could get the last RunningValue in printing. If you have any question, please feel free to ask. Thanks, Tony Chain Tony Chain