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?

Answers were Sorted based on User's Feedback



I am trying to save the XI report to CSV format. the csv file not displaying columns in order. all..

Answer / 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

I am trying to save the XI report to CSV format. the csv file not displaying columns in order. all..

Answer / prakash

Hi,
While saving use the options in the CSV(options)like
Text qualifier and column delimiter.

Is This Answer Correct ?    4 Yes 2 No

I am trying to save the XI report to CSV format. the csv file not displaying columns in order. all..

Answer / padma

Check the order of the columns in report sql.
CSV will be the report sql output and not the report output.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Business Objects Interview Questions

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

0 Answers  


In a Webi Report, Once u r entering a month name,it displays the that month details and after and before month details.How it is

3 Answers   Wipro,


how to test reports in businessobjects?

8 Answers   TCS,


can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ? normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2 Answers   iFlex,


WHAT PROBLEMS ARE NOT KNOWN WHILE PERFORMING INTEGRITY CHECK?

2 Answers   PCS,






Explain how we drill up week to month?

0 Answers  


What is batch processing in Business Objects?

2 Answers  


What is the difference between condition & filter?

0 Answers  


WHO ARE THE USERS OF THE REPOSITORY?

6 Answers   AG Technologies,


When we can use multiple sql statement for each measure? and multiple sql statement for each context?

2 Answers  


What is recurring sheduling and batch scheduling?

2 Answers   TCS,


There is one report running and a user wants to know whether data is from detail table or summary table. what is your approach?

1 Answers  


Categories