title: Reporting Services XML Error
body: <p>Really annoying issue that I have spent a long time on. I shall switch into Software Testing Bug Report mode (from a past life) to explain it.</p>
  
  <p><strong>Scenario</strong></p>
  
  <ul>
  <li>I have modified a SSRS report to work with a new database structure</li>
  <li>The report uses a stored procedure which takes 4 parameters</li>
  <li>One of these parameters has been added to work with the new database structure</li>
  <li>Stored procedure works perfectly in SQL management studio</li>
  <li>Query works perfectly in the query designer window of report builder</li>
  </ul>
  
  <p><strong>Expected Results</strong></p>
  
  <ul>
  <li>I expect that the dataset will show the fields when expanded</li>
  <li>I expect that the report will run correctly</li>
  </ul>
  
  <p><strong>Actual Results</strong></p>
  
  <ul>
  <li>No fields appear under the dataset in the Report Data Pane of report builder</li>
  <li>Report does not run</li>
  <li>I get the following error:</li>
  </ul>
  
  <blockquote>
    <p>There is an unclosed literal string. Line 1, position 64737.
    ----------------------------  Response is not well-formed XML.
    ----------------------------  The attempt to connect to the report server failed.  Check your connection information and that the report
    server is a compatible version.</p>
  </blockquote>
  
  <p><strong>Notes</strong></p>
  
  <p>I have tried everything I can think of, including searching the report definition for unclosed strings but no banana.</p>
  
  <p>Has anyone else come up with this error in SSRS Report Builder?</p>
  
  <p><strong>Technologies Used</strong></p>
  
  <ul>
  <li>SQL Server 2008 R2</li>
  <li>SQL Server Management Studio 2008 R2</li>
  <li>Report Builder 3.0</li>
  <li>Building report on my local machine running Windows 7</li>
  <li>Running report on SQL Server Remote Machine running Windows Server 2008</li>
  </ul>
  
  <p>Thanks</p>