I am modifying an SSRS 2008 r2 report so users can export the data to excel and sort and filter the data. The only way to accomplsh this task is to remove the report headers.
The users will click on a button that says hide 'headers' and click the view button. Then the users will export to excel.
Problem:When the SSRS 2008 R2 report is exported to excel, row one in excel is blank. The column headers and data start on line #2 in excel. I want to remove line #1 from being blank in excel.
To solve this problem, for the tablix that I want to keep, I want to set the location value to 0,0. I do not want to come up with a new report that looks
like the original report but the data is shifted. I would prefer to write C# code to solve this problem since I can not find a way to set the SSRS tablix.location
property in SSRS.
Thus can you show and/or tell me the following:
1. What C# code can be setup to accomplish my goal?
2. How would you attach the C# code to the SSRS 2008 r2 report for the code to work?