I have to make headers in my reports what i want when some one see the report in report viewer it should not show the headers of the report but when i export the report header should be present in to the report. Is it possible to do this.
If you are using SSRS 2008R2, you can use Globals!RenderFormat.Name method to achieve your required output. But using this method, you can hide all the header controls but there will be blank space appeared for the report header in report preview.
Take a look into