I have queries returns a lot of (over a hundred) columns which 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 annoy. Is it possible to disable this SSRS feature?
Or how much work if using the following two methods to fix the headers?
Use script to update the column head from the original column name
Transform the XML reporting rdl file.