Hi,
I have a crystal report with horizontal and vertical lines. When the report is exported to excel, 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 100 fields across 4 sections with subreports.
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 CRXI and CR 2008 and I'm doing MS Excel(97 - 2003).
help would be appreciated.