Skip to Content
0
Former Member
Feb 15, 2011 at 10:00 PM

Excel Export formatting with Subreport

54 Views

We have a number of reports that run with BW data and pull long text data from the ERP system in a subreport. We have the Crystal reports setup so that only the first line of the long text is displayed. The users require that when the report is exported to Excel that the long text act just like any other field in the report and export into a single cell in the excel export. What is happening however is that no matter where the subreport is placed in the main report, when the output is exported the long text from the sub-report ends up on an additional line in Excel. So if there is one row of fields in the detail of the crystal reports and the long text is one of those, the long text will be one row down in the Excel output from the rest of the fields in the Crystal detail line.

So for example:

Invoice Amount Date Long Text

$120.00 12/10/2010 This is the long text line

This should appear in Excel as:

Column A Column B Column C

Invoice Amount Date Long Text

$120.00 12/10/2010 This is the long text line

What we get is:

Column A Column B Column C

Invoice Amount Date Long Text

$120.00 12/10/2010

This is the long text line

Please let me know if anyone has any ideas on how to make this Export as the users want.

Thanks,

Mike