title: Crystal Reports not able to print '&' character
body: <p>I am retrieving data from an SQL stored procedure and displaying it in a text field in a pdf document created with Crystal Reports. </p>
  
  <p>The problem is whenever the data contains an '&amp;' character it only displays the text before that character. </p>
  
  <p>It is being stored in the SQL table as the actual character '&amp;' and when the query is executed the SQL result set shows the correct character as well as when it is being displayed in a browser. But when the report is ran and the same data is being retrieved, Crystal Reports is not able to display the character.</p>
  
  <p>Is there a way to tell Crystal Reports to display the character?</p>
  
  <p>Using SQL Server 2000 with Visual Studio 2008 and Crystal Reports Basic</p>