I am trying to save the XI report to CSV format. the csv
file not displaying columns in order. all the columns are
misplaced. the report size is 12MB
Can any one tell me why the columns are incorrect position
when XI report converted into CSV format?

Answer Posted / lalith

Try few of the following:
1. Make sure all the report headers, details section don't
have any formula that may have invalid expressions.
2. Try to position all the report headers and detail
elements with similar size and alignment
3. Check if you have any extra/hidden Textbox objects
within the detail section.
4. I had similar problem, and had this problem only when
the report is redered to CSV, later i found that one of the
formula i have which displays.." NO DATA FOUND" when
returns null or empty rows and this caused to misplace the
column.. Try it
Best Luck..

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we Save (save as) WEBI Doc as DESKI?

7513


is it possible to export the webi reports to crystal reports?with out using businessview?

2015


Explain about a time when you discovered a more efficient way to do a work task?

838


What is a fantrap in business objects?

804


Explain the data types present in bo and what happens if we implement view in the designer and report?

762






Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

747


Explain in detail about type 1?

866


Which versions are used in the bo dashboard work?

749


Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

797


How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

751


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

796


What is the difference between condition & filter?

1146


Explain the difference between detect alias and detect context?

796


How we drill up week to month?

803


How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

2030