Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

  1. Use script to update the column head from the original column name

  2. Transform the XML reporting rdl file.

share|improve this question
Is this happening in the designer, in the output of the report (CSV, XLS, etc.), or both? – OliverAsmus Mar 15 '12 at 12:22
@OliverAsmus Both – u23432534 Mar 15 '12 at 18:30
Hmm . . . I have not seen this feature as an option in SSRS. However, you can use regular expressions in the column headers to manipulate how the text is displayed - – OliverAsmus Mar 15 '12 at 18:37

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.