Print Page | Close Window

Downloading of report to excel format

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1493
Printed Date: 04 May 2024 at 2:03am


Topic: Downloading of report to excel format
Posted By: l_liteng
Subject: Downloading of report to excel format
Date Posted: 11 Oct 2007 at 2:44am
Hi there,

anyone knows how to format the crystal report with no lines in between each record when doing the exporting of report to excel format. My crystal report has a subreport and right now when I export to excel the output is something like this as shown below.

1   ABC Co   MNC (main report)

1   ABC Co   IT Dept (subreport)
1   ABC Co   HR Dept (subreport)
1   XYZ Co   MNC (main report)


1   DEF Co   MNC (main report)

My crystal report has the problems of leaving one or two lines when I export it to excel but when I export to PDF format it is ok with no lines in between. Anyone out there knows how to resolve this problem so that when I export the report to excel there is no blank lines in between.

Thanks in advance.




-------------
Serine


Print Page | Close Window