Can we take report on Excel in Business Objects?
Answers were Sorted based on User's Feedback
Answer / mkjmkumar
Yes, When u get the output of report then use save as .XLS
option.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / vkrishnabo
Yes, We can take a report on excel in Business Objects,
Process ....
In Desktop Intelligence -> File -> New - Generate a
standard report -> Begin -> Other -> Personal Data Files ->
Finish -> format -> xls & select excel file from browse
option -> If excel file first row contains column name then
select the check box -> First row contains column names ->
Run.
------------------------------------------------------------
If you want to save a BO report in excel format then,
After generating a report file -> save -> File name -
> ....... & save as type -> xls -> Save
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / komali
yes. The businessobjects separately provided the option of
get the report data from universe or others(personal data
option)in the business objects entered wizard. Click or
Select the others option and it will let u different files
or extension files. here select .xls file and follow normal
report style.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / vams_gk
s sure,when we save the perticular report we have a option
to save in .XLs
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sujatha
we can save report as excel sheet, but what can we do if
report has hyperlinks, how to enable hyperlinks in excel
sheet download too? please post the ans if any one knows
about it.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / prasanna.ramesh1
in bo xi we can not generate report on personal file .data
source must be universe.but we can save the report as xl
by selecting save as option.
| Is This Answer Correct ? | 0 Yes | 5 No |
How to create Index to the table in the universe designer and how it improves the Query performence
When we use aggregate awareness function in designer?
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?
What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.
What is the use of Surrogate Key in BO?
1.what is input level context and output level context in webI? 2.what is a cascading prompt? Where will you give this and how? 3. What is External Strategy?
i am using Business Objects 6.1(a) facing a problem. ie when we save report in xls format then in xls sheet pictures are inserted into rep file are not come. Is it a bug. Give me answer as soon as possible. Thanks in Advance
how to connect one to one report? Explain with example?
hi my question is in a report table how can we write table header without using of individual cell.can we merge column cells togrther??
Where will you find the address of repository in Business Objects?
Explain the data types present in bo and what happens if we implement view in the designer and report?
what are the debuggings in the business objects?