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!

Excel Export of Crystal with lines

Status
Not open for further replies.

inspi

Technical User
May 24, 2006
50
US
Hi,

I have a crystal report with horizontal and vertical lines. When the report is exported to excel in Infoview, the users want those lines to be displayed on the excel as well. But when I'm exporting the report, it is not displaying the lines. I can check the gridlines option while exporting but users want the lines to be exactly displayed on the excel export as well. IS there any workaround for this. I dont want to put box on top of each field because of two reasons. 1. there are more than 80 fields across 4 sections.
2. If I put box around the field then the excel export is creating a extra row and column around the field.

I'm using CR 2008 and I'm doing MS Excel(97 - 2003).

Thanks in advance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top