Using Crystal Reports 2008, Visual Studio 2008 with C#. Build the report in Crystal with multiple columns, some of which are narrative and can be quite lengthy. Using the “Can Grow” option on all fields.
Have a web page that displays the report through the viewer, looks great.
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.
Example of Excel Output 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.
Problem occurs when clients export to Excel. The “Can Grow” narrative columns become multiple rows, not the one Row that I need.
This is not a sort-able report 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.
Anybody know how I can accomplish this ? I know that the Crystal Export to Excel isn’t going to do it.
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# ? Is there 3rd party software that will accomplish this?
Thanks in advance !