I work as a reporting analyst for our Support Services department for a medium sized bank in which the data is stored on a hosted sql server database and we primarily use Report Builder. The mindset here has been it's ok to export 5 queries, then copy them to one excel file in different tabs, and use vlookups to create reports. I've made so many improvements in the overall reporting by using SQL-subqueries, views, unions, tce and so on. I don't understand why my manager still won't accept SQL as a solution. My manager doesn't want to learn SQL and actually discourages me from writing in SQL (would prefer that I use Report Builder designer only). How can I convince her/him that SQL should be supported and encouraged to use. Other departments of the Bank freely use SQL to create reports. We are support services and my manager says we won't support other departments use of SQL because he/she doesn't know it. I know I'm doing the right thing because using SQL saves us so much time and it's repeatable with no chance of error compared to copying excel files and creating reports using excel formulas. Please help me understand why would my manager not want to use a better way of accomplishing our job?
Update 2 years later. I didn't give in and my boss now fully trust my knowledge and I've been able to implement many changes/improvements. All of our reports are now created directly in SQL without any manual manipulation of data. I realize this could have gone the other way but I felt strongly about my position and the purpose of why I was hired. In the process the company has recognized these improvements and I have been promoted to professional sr manager level.