EXCEL_DATA_ONLY

Hi,

We have Crystal Report Server w/ Business object.

We are using Business objects in order to access reports via Web services.

We are able to access a report and get it in PDF or excel formats.

Now we need to get a report in EXCEL_DATA_ONLY format

according to this thread export-to-excel-data-only

It is only possible to achieve via scheduling (Please see the end of aforementioned thread).

When I implemented suggested solution

.....

string query = string.Format("cuid://<>", crystalReport.CUID);

rh = bipService.Get(query, null);

Excel newInstance = (Excel)rh.InfoObjects.InfoObject[0];

while (newInstance.SchedulingInfo.Status != ScheduleStatusEnum.COMPLETE)

{

rh = bipService.Get(query, null);

newInstance = (Excel)rh.InfoObjects.InfoObject[0];

}

...

I am getting CrystalReport type in rh.InfoObjects.InfoObject[0]; and not Excel.

Any ideas why?

Thank you very much,

Robert

Edited by: Robert Parker on Nov 5, 2010 10:52 PM