Tell me more ×
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.
up vote 1 down vote favorite

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 – NickW 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 - msdn.microsoft.com/en-us/library/ms157328.aspx – OliverAsmus Mar 15 '12 at 18:37

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.