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?
- 3 Answers
- 8211 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
what is stacked chart , Bar chart, Column chart?
what is the difference b/w star and snowflack schema in dataware house?
explain merge dimensions with real time in DWH?
what are the complex reports you have created. Tell me with example?
when you have three fact table and there is no relationship between them. How you will tackle the issue.
how u link universes of same functional domain ?
2 Answers Business Intelligence Analytics, IBM,
what is slice & dice?
3 Answers Cognizant, Saama Tech, TCS,
User name and password is saved by Business objects when we create repository. and this username and password is saved in Table obj_m_actor table in repository. The password in incrypted form. It is possible to Dycrypt That Password.
What is a loop? How can we overcome?
What is thin client And thick client..?
WHAT IS INPUT CONTROL IN BO?
What is the difference between master-detail and Breaks?
Teradata 
