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

Explain what task is 98% of the required work of a business analyst?

600


Explain the difference between detect alias and detect context?

629


what is universe null

1991


Explain what is aggregate table and aggregate fact table ... Any examples of both?

609


How to open a universe with out using the Designer ??

6616






How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

1971


What is report template in b.o?

588


BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1725


Can you please send me the migration related issues .

1646


What is the difference in creating filters in designer and business objects?

588


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

1910


What is the dense rank?

677


1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?

5975


Explain what are the measure objects?

551


Explain what are the steps to do to use alerts in bo?

615