×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

More excel export issues!

More excel export issues!

More excel export issues!

(OP)
Hi again all,

I have another issue with an excel export.

Basically, I have a shell report which purely contains sub reports.
These subreports work fine by themselves, but when added as a subreport. Some of the fields become merged cells when exported to excel.
I suspected I may have some issues with alignment somewhere, so I suppressed everything except the section with the fields and I still have the issue.
In fact, I have tried to supress everything and this column still comes out as two excel cells merged.

Anyone ever experienced anything similar?

RE: More excel export issues!

Bloke152,

I'm an Excel guy. Never done CR, but I know CR is very useful in the BO/SAP world.

Worked at several aircraft manufacturing plants, so I got reports from other systems to put into Excel. Almost always had problems with these reports. Often had two or three levels of detail that never matched up and took a LOT of time to massage to work properly in Excel.

If I was able to understand where this data came from, I had the ability to get my own data, often from multiple tables in a database, to download that data into my Excel workbook and then manipulate to get the information that was required apart from the report.

I know that our SAP report system had a feature to export a .csv rather than a formatted report to Excel. That was much better. I would IMPORT that file into Excel, using the parsing feature and specify the data type of each column, rather than using Excel to OPEN the file, which can be dangerous!

Bottom line: getting a complex REPORT into Excel for analysis and reporting can be a huge pain for the Excel user.


Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

RE: More excel export issues!

Lining up columns when exporting to Excel from Crystal is key. Including headers. It is a real pain. But possible most of the time.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close