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 |
Suppose we had a scenerio like in an universe there are nearly 250 objects but only 50 objects data is updated frequently so is there any way to overcome it.(Birla Soft,)
What is difference between merged dimension and forced dimension??
Explain about alerts in bos, under what situation we need to use alerts?
What are different types of saving options in web intelligence?
how to sort on a particular object,that object is not picked up while creating the cross tab but we need to sort on the object that is not in the cross tab????
2 Answers Infosys, Keane India Ltd,
when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGNING UNIVERSES?
Difference between b.o 5.1 and 6.1b?
difference between web intelligence,crystal reports and desktop intelligents
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Difference between Decode and Case?
8 Answers Polaris, TCS, Wipro,
Explain how to execute the plsql procedure from the report by clicking with mouse?