Crystal Reports Exporting to Excel

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Exporting to Excel

Post Reply

Post New Topic

Author	Message
thesmug1 Newbie Joined: 12 Jun 2009 Online Status: Offline Posts: 13	Topic: Exporting to Excel Posted: 10 Aug 2009 at 1:11pm
	When I export a report to Excel there is always an extra line between each line of data. For instance, the excel file will be as follows: Line 1: data (Line 2 will be completely minimized) Line 3: data (Line 4 will be completely minimized) etc Is there any way to get rid of those minimized lines besides manually deleting them?
	IP Logged


bmurphywa Newbie Joined: 07 Aug 2009 Online Status: Offline Posts: 15	Posted: 10 Aug 2009 at 1:24pm
	First make a back-up of the Excel file in case you do not like the result of what follows. In Excel, highlight the entire area yu want corrected. Then: Data>Filter>Advanced Filter Select Unique Records Only and OK. This assumes the blank rows are the only totally identical rows in the spreadsheet. Since the blank rows are not unique they will be filtered out.
	IP Logged

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum