SSRS repeat header on each page

http://remicaron.wordpress.com/2010/01/05/how-to-get-ssrs-to-repeat-the-row-headers-tablix-2008/

Auto Login windows server

1. In the Start menu click Run and enter control userpasswords2. After clicking OK  to the User Accounts window will show up.
2. Now click the account you want to login automatically and uncheck Users must enter a user name and password to use this computer checkbox. If you now click Apply it will ask for the password of the user you selected. Enter the password of the selected user twice and click OK. From now on every time you start Windows it will automatically login!

SQL server change timezone

SQL server change timezone. Change server's timezone. Go to Properties > Advance and change the language to English. Go to Security > Logins > Edit user and in general select language to English.

Could not load type System.ServiceModel.Activation.HttpModule

Could not load type System.ServiceModel.Activation.HttpModule http://devonenote.com/2010/06/could-not-load-type-system-servicemodel-activation-httpmodule/

Show and Hide leaves blank space.

Tablix can solve issue http://www.sqlchick.com/entries/2011/3/5/dealing-with-white-space-due-to-a-hidden-textbox-in-reportin.html

Add Row Group in SSRS

http://sql-bi-dev.blogspot.in/2010/09/groups-in-ssrs-2008.html

Could not load file or assembly dll Access is denied

Found the issue was related to impersonation. Some calls where impersonated and the impersonated user did not have rights to %SystemRoot%\Microsoft.NET\Framework\versionNumber\Temporary ASP.NET Files