BOXIAPI does not support reports saved in xls format,

[Former Member]

Support Case for BOXI

Title: BOXI API does not support export excel file,graphs chart missing from reports saved in xls format

BOXI version: Business Objects boe XIR2 SP2

OS: PARISC HPUX 11.11

Description:

It works correctly while export reports saved in PDF format.

When I save a report in xls format, chart graphs are missing. Html and pdf formats are fine.

any body can help me？ thanks！

However the export as xsl format is not work in the API.

[Former Member]

Hi Ted,

Thanks for your reply, yes I using Web Intelligence documents export excel format from InfoView , I defined Excel format output, but there have no chart just have data in the excel document.

you told me 'Note that Excel export, depending on document type, will be data only - no charts.'

you deeming at the InfoView if I defined Excel format output, will be data only - no charts, am i right?

If our customers need to be make to order the excel format output and include chart, how should solve?does make use of SDK to develop program by ourselves?

[ted_ueda]

You'd have to specify the document type - are you using Web Intelligence documents?

If you export to Excel from InfoView for your particular document type, that will tell you the defined format output.

Note that Excel export, depending on document type, will be data only - no charts.

Sincerely,

Ted Ueda

[Former Member]

Hello,

-A feature of exporting a report to XLS format is supported in BOXI API.Also graphs,charts also gets exported correctly.

-Have you copied all the necessary JAR files to your application lib directory? Please make sure that all the relevant JAR should be present inside lib directory of your application server.

-Below is the sample code to export a report to xls :

ReportExportControl exportControl = new ReportExportControl();

exportControl.setName("ExportControl");

exportControl.setExportAsAttachment(false);

ExportOptions exportOptions = new ExportOptions(); //Set export options and format.

ReportExportFormat exportFormat = ReportExportFormat.MSExcel;

exportOptions.setExportFormatType(exportFormat); //Set the format for the export options

exportControl.setExportOptions( exportOptions ); //set the exportOptions to the viewer

-Apart from this, I would suggest you to go through following link :

http://devlibrary.businessobjects.com/BusinessObjectsXI/en/devlib.htm-->Viewers SDK-->Java developer guide----->viewing and exporting features

Thanks,

Chinmay