Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

exporting to Excel

Status
Not open for further replies.

luv2bike2nv

IS-IT--Management
Jun 28, 2007
90
US
Crystal Reports 8.5
MS Office 2003

There is a report that one of my users exports to Excel. when he exports it with there are two problems.

In the page header and in the details section there are 10 items. in Crystal they align correctly however when he exports it to Excel the 5th item (both in page header and in the detail section) come out on the line below.

ie
in crystal reports Page Header
name address city state zip phone

in excel
name address city zip phone
state

in crystal reports detail
John Doe 123 main street fake city CT 06422 203-555-1212

excel
John Doe 123 main street fake city 06422 203-555-1212
CT

is there a way to correct this?

thanks :)
 
corrected the problem--made the page header and detail lines small instead of 1/2" in height I changed it to 1/4" in height
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top