Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8601 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 |
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
how to connect one to one report? Explain with example?
1. what are the differences between prompt at universe level and prompt at report level ? 2. what are the connection types in BOXI ? 3. how do we give the security in universe level ? and report level ? and objects level ? 4. what will happen if we check the 'MULTIPLE SQL STATEMENTS FOR EACH MEASURE' option in Universe SQL parameters ?
Pls say any one... how will u create a report using oracle stored procedure? could u pls send me the step.....
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
Which outer join is used in Merge Dimension. Diff between merge and auto merge dimension.
2 Answers Cap Gemini, Infinity, TCS,
what r the types of joins universe supports
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
What is batch processing in Business Objects?
How to get top 5 rows of a selected column?
date format in report like (22/5/2010 "3:20:15 am") like this i want to remove 3:20:15 remove from report how can we do this in bo xi r2
Teradata 
