How to run a report, get data set, and use it

[Former Member]

I'm writing an application where I hope to do my own presentation of the data, but I'd like to use Business Objects to get the data. So I'm picturing a user providing my application some Business Objects credentials which I'll use to log in, navigate to a particular report, run it using some input provided by the user, and get a dataset back. Then I hope to navigate that dataset and use it to create the output from my application. The user never needs to see the report as formatted by Business Objects. Any suggestions? For what it's worth, I can already log in, get an InfoStore object, and use it to navigate to a particular document. The part I can't yet do is create an instance of that document, filling prompts with user-provided data, and run the report. Thanks in advance.

[Former Member]

Can a similar thing done with the webservice API as well ? I want to retrieve the data by using webservices and display it using a UI of my choice . Is that possible?

[ted_ueda]

Which type of document, Crystal Reports or Web Intelligence?

Or are you looking towards Query as a Web Service (QaaWS)?

Sincerely,

Ted Ueda

[Former Member]

Query as a Web Service would be neat, except that we don't have it A WebI document would be best. Actually, I think I've found the answer through the ReportEngine SDK. For posterity (note that this is Jython code, so typecasts aren't done where they would be in Java):

reng = sess.getService("", "WebiReportEngine")

doc = reng.openDocument(<SOME DOCUMENT ID>)

dps = doc.getDataProviders()

dp = dps.getItem(0)

a = dp.getResult(0)

a is now a Recordset object (http://devlibrary.businessobjects.com/BusinessObjectsXI/en/en/RE_SDK/resdk_java_doc/doc/API/com/businessobjects/rebean/wi/Recordset.html) and can be navigated as required.