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

How to restrict password to a user while sending a document in .pdf format

0 Answers   Mphasis,

in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level

3 Answers   Accenture,

What is recurring sheduling and batch scheduling?

2 Answers   TCS,

how to limit number of rows in a report in business objects using webi?

3 Answers   Cap Gemini, TCS,

5.what is LOV? where it is store?

3 Answers   TCS,




Explain about Short cut join?

2 Answers   Wipro,

When any new universe changes are deployed how does the end user get the view of the new classes/objects added(aprt from specs doc)?

4 Answers   IBM,

how get the grand total in master-detail report?

0 Answers   Patni,

What is the difference between derived table and views? which one gives better performance?

2 Answers   TCS,

@prompt('message',['type'],[lov],[mono/multi], [free/constraint]) what is Constraint?

4 Answers   iGate,

whats the Diffrerence between business objects and cognos?

1 Answers  

What is meant by ZABO and FC(full-client)?

2 Answers  

For more Business Objects Interview Questions Click Here
Categories