I have a query that returns over a hundred columns. The column names contain important underscores, >, < and Uppercase/lowercase characters. However, when creating the reports, SSRS designer (3.0) automatically added spaces and convert these special characters to spaces. It's really annoying. Is it possible to disable this SSRS feature?
How much work would it be to fix the headers using the following two methods?
Use a script to update the column header back to the original column name.
Transform the XML reporting rdl file.