BusinessObjects Board

Button in title to refresh and export report data

sdk development
#1

I am a starter on VBA customisations of BO reports.
I would need to create a button, which will bne placed on top neat the standard BO buttons (title area). When the button is clicked the report would be refreshed and the export in XL would be saved in the local folder.

Can any one pls provide the code, to create the button in the title area and its functionality.

Thanks.

cubic coma (BOB member since 2006-09-16)

#2

May I make a suggestion? If you put the “export to Excel” code in the AfterRefresh event, you won’t need a special button. If the user presses the built-in Refresh button, the export would still happen automatically.

That said, if you are looking for examples to create toolbars / menus, you can look at this utility.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)