We help IT Professionals succeed at work.
Get Started

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

712 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:
This problem has been solved!
Unlock 4 Answers and 5 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE