Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

More excel export issues!

Status
Not open for further replies.

Bloke152

Programmer
Aug 9, 2005
123
NO
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?
 
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]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top