title: Crystal Reports Exporting to Excel with Can Grow
body: <p>I'm using Crystal Reports 2008, Visual Studio 2008 with C#. I build the report in Crystal with multiple columns, some of which are narrative and can be quite lengthy. “Can Grow” is on for every field.  </p>
  
  <p>I also have a web page that displays the report through the viewer, which looks great:</p>
  
  <pre><code>Web Page / Crystal Viewer
  Date            Narrative                                     Region
  08/16/2010      It was a rough day for several Chase          USA
                  contenders. Kurt Busch blew an engine, 
                  Mark Martin damaged his car early and 
                  spent most of the afternoon running 
                  outside the top 30, and Jeff Gordon was in 
                  the top 10 then he had a flat tire with 47 
                  laps to go.
  </code></pre>
  
  <p>Example of Excel Output:</p>
  
  <pre><code>ROW
  1 Date          Narrative                                    Region
  2 08/16/2010    It was a rough day for several Chase         USA
  3               contenders. Kurt Busch blew an engine, 
  4               Mark Martin damaged his car early and 
  5               spent most of the afternoon running 
  6               outside the top 30, and Jeff Gordon was in 
  7               the top 10 then he had a flat tire with 47 
  8               laps to go.
  </code></pre>
  
  <p>The problem occurs when clients export to Excel: The “Can Grow” narrative columns become multiple rows, not the single Row that I need.</p>
  
  <p>The report isn't sortable due to the Narrative being in Multiple Rows. 
  I can export it into Excel through the “Data Only” option, but then it requires user manipulation before it is readable.  </p>
  
  <p>Anybody know how I can accomplish this? I know that the Crystal Export to Excel isn’t going to do it.</p>
  
  <p>I am the SQL / Crystal Developer and know very little about the Web/C# portion of this. Can I export to an Template through C#? Or is there some 3rd-party software that will accomplish this? </p>