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 |
Once the project is submited to the Client. Client says that report is taking long time to run? Where u need to check?
How to create a tooltip in Webi? Is there a way to create Tooltips in Webi reports for non- hyperlinked columns? Users should be able to hover over a value in a column in the report and that should show a tooltip box with more detail regarding that column value. This is possible when you hyperlinked the column,Is it possible when you dn't have hyperlinking? Thanks in advance.
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?
Any one suggest me best SAP Business Objects XI Online Training institute from India
Differences between business objects and web intelligence reports?
if the project is assigned for you and the client said yo wait for a month,What will you do in that time?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
can i use stored procedure in webi?
Can anybody explain breifly about 5 tier's of BOXIR3. 1. Client tier 2. Application Tier 3. Intelligence Tier 4. Processing Tier 5. Data Tier
What is thumbnail?
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ? normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
How to Analyise 'Join' problem and which method is the best to resolve that ?