We help IT Professionals succeed at work.

Crystal Reports 8.5 exports to excel 8 xls results in file with every other line blank

Medium Priority
700 Views
Last Modified: 2012-08-13
I am at a client's site. They are using Crystal Reports for ACCPAC Advantage Series v8.5

They have numerous reports that are called by WinAutomation v 3.1.6.676 Professional.

WinAutomation jobs first set some variables which call up predefined Crystal Reports. The reports run are then 'FORMATED' as EXCEL8 XLS and saved to a folder, which then FTPs the file to a site and then emails the client that their file is at the site for them to pick it up.

I am having problems with one report. I have run the report outside of WinAutomation so that we could take that out the mix.

When I run the report in Crystal Reports manually and then export to EXCEL8 XLS Format with destination as disk and save it to my desktop, the resulting .xls file shows an additional line between each line. So the report shows data on lines 1,3,5,7,9 and there is a blank row on lines 2,4,6,8. I run a similar report and it is fine.

There has to be something in the problem report that is adding this blank row. I am too new to Crystal Reports to know much about how reports are formated or created.

Thanks in advance.

Rich
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Have you already confirmed that the crystal report is not designed to add the extra line?

CERTIFIED EXPERT
Commented:
Any chance you can upload the report?
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
Is there a subreport in the report?

Do you have a field that is taller than the others in the line?

Here is a paper on how to format a report so it exports to Excel.
http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/20c9c239-7b64-2b10-4ab3-b59d52ed35de?QuickLink=index&overridelayout=true

mlmcc
CERTIFIED EXPERT
Top Expert 2011
Commented:

Author

Commented:
My apologies for the slow response.

I found that by clicking and slowly dragging the bottom line of the field upwards just a tiny bit, that when the report ran, the extra line between items disappeared.

Thanks fot all that contributed to the conversation.

-Rich

Explore More ContentExplore courses, solutions, and other research materials related to this topic.