title: Exporting multiple page headers in crystal reports (in visual studio) to Excel
body: <p>I'm having a heck of a time trying to manipulate my reports so that when i do a data-only excel dump, excel can recognize page headers.  I was wondering two things.</p>
  
  <p>1.)  Is there any way to change excel export options in Visual Studio?  I know you can do this with Crystal Reports standalone...but unfortunately my project requires the use of VS. </p>
  
  <p>2.)  How do i get the following to print:  </p>
  
  <p>{Report Header}<br>
  (NOTE:  this is supposed to be a box containing the following info)<br>
  Query:<br>
  Sort:<br>
  Aggregation:<br>
  Date:<br>
  {Report Header}  </p>
  
  <p>{Page Header A}<br>
  -----------TITLE------------               -----------TITLE------------<br>
  {Page Header A}  </p>
  
  <p>{Page Header B}<br>
  [Page Header]  [Page header] [page header] [page header] [ page header]<br>
  {Page Header B}  </p>
  
  <p>Every single time i print this, the Report Header gets stuffed into a row.  Page Header A doesn't show up at all...and Page Header B shows up fine.  Is there a way to get around this???  I tried merging both headers...but then only [Page Header] shows up and not the Titles above it.  </p>
  
  <p>Any ideas??</p>