August 30, 2012 at 8:57 am
Is there any way to force SSRS to keep the formatting of the field names from the data set? All fields with an underscore have this character replaced by a space, pretty annoying if you've got a report with tons of columns and you've got to replace the underscore on every field!
I've Googled it, to no avail. I wondered if anyone here knew of a way around this behaviour?
December 26, 2014 at 7:35 am
I'm sure this will not matter to op, but for sake of anyone like me who hits on this page in the future here is one update. I thought I had this problem for a long time, never found solution. Tried replacing underscore with different or fake underlines from various character sets, but nothing worked. Underscores were replaced by spaces in all of my data grids, and sometimes but not always in column headers. Usually (maybe always) this problem did NOT appear when developing in Visual Studio...it only happened after the report was deployed to a prod SSRS server. From my experience with SSAS I know full well that MS is not beyond doing something awful like this and saying it is by design, so I eventually gave up.
Last week I thought I noticed lowercase G descender was being clipped off in one of my reports, so I increased the height of data grid text box. Next time I ran report in production, the underscores showed up!
If you think you have this problem, try increasing text box's height.
January 6, 2015 at 4:35 am
Thanks for the reply! It's still a problem which I'm just living with tbh, accepting that I have to whizz through a report and change the column headings. Usually it's not too much of a chore but some reports are in excess of 100 columns.
The height of the text box didn't seem to make any difference. If a solution does pop up I'd be curious to see it, for now I've just accepted it as intended design which can't be avoided.
Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply