title: Deploying the Microsoft Report Viewer as a Prerequisite in VS 2012
body: <p>When I try to include the Microsoft Report Viewer 2012 Runtime as a prerequisite in a ClickOnce deployment in VS2012, I receive the following warning:</p>
  
  <blockquote>
    <p>The 'Microsoft Report Viewer 2012 Runtime' item selected requires
    'Microsoft.SqlServer.SQLSysClrTypes.11.0'.  Select the missing
    prerequisite in the Prerequisites Dialog Box or create a bootstrapper
    package for the missing prerequisite.</p>
  </blockquote>
  
  <p>First of all, there are two prerequisite options for the SQLSysClrtypes - a 32-bit version and a 64-bit version.  Which one do I include?</p>
  
  <p>Also, no matter which one I select, I receive the error: </p>
  
  <blockquote>
    <p>To enable 'Download prerequisites from the same location as my
    application' in the Prerequisites dialog box, you must download file
    'SqlClrTypes_x86\SQLSysClrTypes.msi' for item 'Microsoft System CLR
    Types for SQL Server 2012 (x86)' to your local machine.</p>
  </blockquote>
  
  <p>However, I cannot seem to locate a redistributable package file for this.</p>
  
  <p>Which version of these SQL CLR types do I need to include and where do I get the bootstrapper package?</p>
  
  <p><strong>Update</strong></p>
  
  <p>I found a MSDN article (<a href="http://msdn.microsoft.com/en-us/library/ms251723.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/ms251723.aspx</a>), and under the section that discusses ClickOnce publishing, it explicitly states:</p>
  
  <blockquote>
    <p>"Make sure that the Download prerequisites from the component vendor’s
    website option is checked. This is the only supported option."</p>
  </blockquote>
  
  <p>This seems a little crazy since not every computer has Internet access -- definitely not in my organization.  Can anyone confirm this?</p>