Export to Excel Data only

[Former Member]

Is there any way to export to excel data only format through web services? I can figure out how to export to excel but not data only.

Thanks in advance...

[joshua_morin]

Ping...

I've taken over for the OP and am still interested in this capability. Has anyone successfully exported as Excel in data only format? I'm currently at the same point as the OP and that I get the "unable to retrieve binary view"

HELP!!!

Regards.

Edited by: Joshua Morin on Oct 6, 2009 7:11 PM

[aasavaribhave]

Try adding

1. ViewSupport object and set OutputFormatType is Excel.

2. Add refresh() action in getDocumentInformation call.

[Former Member]

I am also unable to get the plugin exporter working. Does anyone understand how altering the Crystal Reports object in memory (as this example suggests) would affect the docinfo object you retrieve later on? They appear to be completely unrelated in my testing. Here are my findings when setting the EXCEL_DATA_ONLY format for the plugin:

- Set the ViewSupport to basic binary

-- Results: I get a binary report result, same result as if you don't touch the original Crystal Report *(not readable by excel)

OR

- Set the ViewSupport to EXCEL

-- Results: I get an Excel document (not in data only format), again same result as if you don't touch the original Crystal Report

With both tests I tried 'refreshing': before the prompts, after the prompts, not at all.

Has anyone figured this out?