Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Reporting Services Export not working properly

Author  Topic 

reefmespla
Starting Member

3 Posts

Posted - 2008-09-10 : 10:30:08
Hello all,

I have a report that I built that is exporting a column that is a textbox text constant that reads:
"Small Group A+"

The report renders fine to everything except Excel 2007. When I do the excel export the text is rendered as:
"Small Group A&"

Does anybody have any suggestions on what can be done to make the A+ export as A+ instead of A&?

Thanks

dexter.knudson
Constraint Violating Yak Guru

260 Posts

Posted - 2008-09-10 : 20:24:41
This is a bit clunky & may not work, but you could try entering <="Small Group A" + chr(43)>
in your textbox.
Go to Top of Page

reefmespla
Starting Member

3 Posts

Posted - 2008-09-11 : 09:01:39
Dexter, that worked perfect, thanks for the help!
Go to Top of Page
   

- Advertisement -