Skip to Content
0
Apr 23, 2009 at 06:29 PM

Report Painter Report - Leading White Spaces in Cost Element

55 Views

When calling up a report painter report, e.g. S_ALR_87013613, with cost element characteristic in Office integration/Microsoft Excel as output parameters, the cost element (row item) is indented with white spaces. The number of white spaces seems to be in relation with summation levels (sub-totals) visible in the left panel. For some cost centres that only have limited transactions, such as no posting to salary account group, there are less levels of summation, meaning less leading white space in cost elements. Is there any way to eliminate or have a fixed number of leading white spaces in cost elements?

We export the report to Excel worksheet for further processing. VLOOKUP function is used to read the cost element into another workbook. The inconsistent number of leading white spaces creates a problem for the formulas to work properly.

Any suggestion is appreciated.

Regards,