Exporting data

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
Gordon
Chargeable-Services-V3.rpt
chareable-test.xls
Gordon HughesDirectorAsked:
Who is Participating?
 
mlmccCommented:
The export to Excel is designed to export the subreport to the "next" row.  There is nothing you can do about that.

Exporting to Excel requires specific formatting of the report.  It can be a bit ugly in preview.

There can be no space between objects that are side by side.  If there is the export inserts a column.
Similarly there cannot be any space vertically between the rows (no extra space in the section)

Columns must align on the left and right if they don't then you get some merged columns.

You can have a wide column with more than one under it so long as the left ones align on the left and the right one align on the right

See what I have done to the left half of the report.

mlmcc
Chargeable-Services-V3rev1.rpt
0
 
Gordon HughesDirectorAuthor Commented:
Hi mimcc
Well you have answered my question
The export to Excel is designed to export the subreport to the "next" row.  There is nothing you can do about that.

So need another approach, maybe a macro in excel to put the data in the correct columns and remove blank lines
I have managed to get the report to only have 1 blank row in excel
Gordon
0
 
Gordon HughesDirectorAuthor Commented:
Hi mimcc
How do I close this question without a complete solution
Gordon
0
 
Gordon HughesDirectorAuthor Commented:
Have resolved using an Excel macro
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.