I am trying to save the XI report to CSV format. the csv file not displaying c

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

3 Answers
8753 Views
I also Faced
E-Mail Answers

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

in universe perameter u dont give the option multiple contexts ,what is the impact in report level

2 Answers Accenture,

Tow tables is there employee, projects . (many to many) one employee has different projects and one project has different employees . how we can achive the data from both

2 Answers Hexaware,

How many built-in objects are created in Business Objects repository?

2 Answers

how to schedule a report for even number dates?

2 Answers HCL,

In a column if the value is >10000, it has to show downwards Arrow in green color, If the value is <10000, it has to show upwards arrow in red Color.... How to achieve this?

4 Answers Cap Gemini,

how to create dashboard reports

4 Answers TCS,

what is the difference between input file repository server and output file repository server ?

2 Answers CTS,

4.what is aggregate awareness ? how do we use ? where do we use ?

2 Answers Accenture, Aegis,

Can anybody explain me the following Authodications? Enterprise,LDAP,Standalone,Windows AD and Windows NT ?

1 Answers

I have saved one file in GMT as a standard time and the server must convert it into local time. How to do it?

1 Answers IBM,

what is xcelsius architecture?

0 Answers Zensar,

Hi, i have 10 data providers in report? i want to see only two data providers remaining are hide? how can do it? Thanks&Regards raghu.shiva

1 Answers

For more Business Objects Interview Questions Click Here