How to link bo report with excel or wanted to export report into excel

[Guest_imported]

hi everyone
am new to Bo
i have created a simple report and wanted to link it with excel or export data to excel as and when i run the report.can i do it? how, kindly guide.

another query

if i wanted to create a user interactive report which asks for entering month and thus i shld get the data of that perticular month only.
this is wht i wanted
to_char(hiredate,'mm')= prompt value entered in months
and accordingly i shld get the data for eg user entered 9 the report containing all the data of september should come.
how do i do it

thnks and regards

 

[jimbopalmer]

i am on BO 4.13 there is a "rubik's cube" icon that has export button. you can say to export to .XLS for a snapshot or export special to DDE and the report is 'linked' to BO I love everyone til they prove otherwise, sadly some prove otherwise SO quickly

 

[Guest_imported]

1) a) menu-->data>view data. window will open, click the export command button and select the path, file name and format of the file and click ok. This will export the the data from the report to the format you mention.
You can also Use excel sheets to generate the reports

b)Every time you need to go thru the above mentioned steps to export the data.
To avoid this you can write a vba code that will export data every time you refresh the report.
Follow the steps to do this..
menu-->tools-->macro-->visual basic editor.
paste the code
(Private Sub Document_AfterRefresh()
ActiveDocument.ActiveReport.ExportAsText ("c:\query.xls&quot
End Sub) you can make changes as u wish. save and close the editor, now u dont need to worry about the export file everytime.

2) In the data provider drag the month object into the condition window. Select the operator by double clicking the operator you want from the operator window. Select a operand type as 'Type a new prompt' by double clicking it from the operand window, and write "Enter a Month"... and run the report, the report will ask you to enter the month and data will be according to the month..

I Hope this will solve your queries

Shyam