title: Embed SQL Password into Crystal Reports RPT file?
body: <p>We are experimenting with Crystal Reports viewers such as this one:</p>
  
  <p><a href="http://www.thereportviewer.com/" rel="nofollow noreferrer">http://www.thereportviewer.com/</a></p>
  
  <p>... which can actually re-connect to the data source and re-run a Crystal Reports RPT file with live data.</p>
  
  <p>However when running the report the viewer asks for a password to connect to the data source (in this case SQL Server).</p>
  
  <p>Does Crystal Reports have some way of embedding a connection password into a RPT file to avoid this? Or should I be using a System DSN from the Control Panel/ODBC thing to get around this?</p>
  
  <p>I figure someone else must have had this problem.</p>