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,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

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