A project costing report of my client recently had a problem downloading their report via spool into an excel file. The report was not align accordingly to the cells in the xls file. All records in the report were merge as one string and assign to a single cell at the first column in the xls file.
So we grouped together a few ABAP consultants and functional consultants to figure out what was the possible solution to enable the ABAP report to be downloaded into xls via spool correctly. So to say, we need to figure out how to make each column in the ABAP report correctly downloaded into each xls column as exactly as it is.
After several days of searching, the functional found an OSS notes, 78401, that describe our problem (symptom) and prescribed a solution. The solution was to provide the ABAP report to be optically identifiable by vertical lines so the spool knows what are the columns. Currently, the report in question was a classic ABAP report and no lines to indicate what were columns in the report. That makes sense. So an ABAP consultant was set to convert the classic report into an ALV report.
The result, it solves the problems. Now, the customer can happily download their report into xls format via the spool without any problem.
OSS NOTES : 78401.
is sky the limit... no vertical lines in report can make the spool blind.
No comments:
Post a Comment