This document provides a way get the failed instance information using the BusinessObjects Enterprise Platform Java SDKs and export to Excel. It is a continuation of the document http://scn.sap.com/docs/DOC-57558.
Have seen requirements where people have requested for the same information in an excel and I am adding the excel export options to the existing documents.
For more scripts and information on how to run these scripts refer to the blog avaiable here:
Below is the Java Server Pages (JSP) sample
- You would need to change the userName, password, cmsName to the values specific to your enterprise server in the provided sample code. Also would need to provide the location where you need the excel to be exported.
- You would reuire the poi-3.5-FINAL.jar file in your applications lib along with BusinessObjects jar files.
- The part of exporting the results to an excel file does not come under the support of BusinessObjects as you would be using third party jars with BusinessObjects jar files to have the results exported to excel.
|Failed Instance Info|
<%@ page import = “com.crystaldecisions.sdk.framework.*”%>
HSSFWorkbook wb = new HSSFWorkbook();
HSSFRow row = sheet.createRow((short)index);