Information Technology

Export Business Object Reports to Excel

Follow these instructions to allow Business Objects reports to be exported to Excel with no issues

 [[{"type":"media","view_mode":"media_large","fid":"304103","attributes":{"alt":"Export Business Object Reports into Excel","class":"image-original-click adaptive-image media-image","desc":"Export Business Object Reports into Excel","height":"380","mm_media_margin":"1","mm_media_outlined":"1","nid":"583423","style":"border: 1px solid black; margin: 10px;","title":"Export Business Object Reports into Excel","width":"373"}}]]

While in Internet Explorer, Click Tools and select Internet Options.

[[{"type":"media","view_mode":"media_large","fid":"304105","attributes":{"alt":"Export Business Object Reports into Excel","class":"image-original-click adaptive-image media-image","desc":"Export Business Object Reports into Excel","mm_media_margin":"1","mm_media_outlined":"1","nid":"583423","style":"border: 1px solid black; margin: 10px;","title":"Export Business Object Reports into Excel"}}]]

Select The Security Tab.
Then select Custom Level.

 [[{"type":"media","view_mode":"media_large","fid":"304106","attributes":{"alt":"Export Business Object Reports into Excel","class":"image-original-click adaptive-image media-image","desc":"Export Business Object Reports into Excel","height":"430","mm_media_margin":"1","mm_media_outlined":"1","nid":"583423","style":"border: 1px solid black; margin: 10px;","title":"Export Business Object Reports into Excel","width":"383"}}]]

Scroll down to the Download area which is a little under half way down and choose Enable on the “Automatic prompting for file downloads”.
Click Ok
Click Apply.

Business Objects

The Web Intelligence Business Objects reporting tool enables authorized users to securely access Amherst College administrative data using a web browser. Report developers with database expertise in their area have secured access to data to write reports.