1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

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?

Question Posted / mrs.narmatha

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 ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?

4 Answers   Ericsson, Nokia,

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  

What is the link option in the reporting Environment?

3 Answers  

What is security level in BO ?

3 Answers   Accenture,

What is the error that occurs while detecting the cardinalities in the universe pane if we create a join between the normal table and the aggregate table...

1 Answers   TCS,




What is the BO project Architecture? Explain in detail? Thanks in advance for ur answers?

2 Answers   Patni,

What is the difference between condition & filter?

0 Answers  

What is a Set?

1 Answers  

IF I WANT TO INSTALL BO ENTERPRISE PRODUCTS IN WINDOWS 2000 PROFESSIONAL SERVER ,WHAT SHOULD BE THE SYSTEM CONFIGURATION?

1 Answers   AG Technologies,

what is confirm dimension ?

11 Answers   IBM, Wipro,

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

0 Answers  

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

2 Answers  

For more Business Objects Interview Questions Click Here
Categories