Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Special Characters in field name Expand / Collapse
Author
Message
Posted Tuesday, July 23, 2013 7:29 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 10:43 AM
Points: 224, Visits: 332
Hello all. I have a situation where my company has a report which has fields named with special characters such as 401k_$ and 401k_%. As you know the $ and % will be stripped out by SSRS and replaced with either an _ or a blank. This is causing many issues with our reporting. Is there anyway, aside from manually renaming the fields in the reports(since this is a 3rd party reporting tool and the name of the fields come directly from the SQL statement) to pass the special characters and have SSRS hold on to them in the name of the field?

Any help would be greatly appreciated.

Thank you.
Post #1476569
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse