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?
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 |
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
how do u implement dense rank in bo reports?
What problems you have faced while creating an universe? tell me an incident and how you went about solving it?
what is xcelsius architecture?
any of the person working on encyclopedia? give the explanation briefly?
how to link 3 fact tables
how to create dashboard reports
What are the major problems will occur while migrating to the one version to another version?
how to coneect to a server in a business objects
Is there any other repository domains rather than universe, security, document?
How do you find what type of trap is there by seeing the report?
what is zero client and thin client ?