I am trying to export data from a crystal report to excel but for some reason the data will not align with the headings and produces extra blank rows
I am using Logicity Solution Builder to run the report and exporting the data as an Excel Workbook Data-Only (*.xlsx) file or a Mircosoft Excel 97-2--- Data Only (XLS) from Crystal Reports
The xlsx contains the column heading but the XLS removes the heading (the xlsx is the preferred route
The heading seem all ok but the information from the sub report appears on the next row with a couple of blank rows
Have attached the rpt file with data and the excel file (XLS) file, the sytem will not allow me to upload the xlsx file!!
Any ideas, I am sure the problem lies with the crystal reports set up