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.