Sign Up Login


  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

while developing a report in BO i had created prompts at query level? When an end user runs the report he has to see the details of the report with out entering the prompt values? How can we do this in BO?

2 Answers   PWC,

HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?

2 Answers   Polaris,

if we run a report it is taking so much time to display the report,what to do to increase th performance of the report

3 Answers  

If the Hi-rarchies are not defined in the universe level .Is it possible to do in the report level?

3 Answers   Infotech,

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

0 Answers   Mphasis,

What are all difference between business objects 6.5 and xi r2?

0 Answers  

is there any limit for rows and columns in cross tab

4 Answers  

What is the strategies ? what is the need of the strategies?

2 Answers   IBM,

I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

0 Answers  

What is DSS?? (Defination of DSS)

2 Answers  

normally we get many contexts when resolving loops or traps,how do u take them to reports.

2 Answers   Wipro,

how to create dashboard reports

4 Answers   TCS,

For more Business Objects Interview Questions Click Here
Categories