Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  Running total not displaying in print preview

Author  Topic  vinu Starting Member 34 Posts Posted - 2010-10-06 : 00:59:36 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