title: SQL Reporting - multipage EMF report issues
body: <p>I would love anyone's assistance regarding this issue.  The issue has been the bain of many in that rendering an EMF format report programattically does not work in SQL2008 R2 and also SQL2012.</p>
  
  <p>This is logged through MS connect here: <a href="https://connect.microsoft.com/SQLServer/feedback/details/560911/sql-2008-r2-reportexecutionservice2005-broken-with-image-emf#tabs" rel="nofollow">https://connect.microsoft.com/SQLServer/feedback/details/560911/sql-2008-r2-reportexecutionservice2005-broken-with-image-emf#tabs</a></p>
  
  <p>In summary, when calling the Render method of the ReportExecutionService object, it gives back the first page along with an array (via output parameter) of stream IDs to map the subsequent pages.  You then call the RenderStream method on that stream for each subsequent page. Works great in 2008.  In 2008 R2 / 2012 the array of stream IDs comes back empty meaning you only get the first page - making it useless.</p>
  
  <p>I was happy to see that MS released a hotfix for 2012 to fix it: <a href="http://support.microsoft.com/kb/2637802" rel="nofollow">http://support.microsoft.com/kb/2637802</a></p>
  
  <p>However, after installing the hotfix / restarting / etc, I still have the problem. Has anyone gotten the hotfix to work?  Had the same experience? Know a workable solution for a large report?</p>
  
  <p>Thanks for any assistance.
  Steve</p>