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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.