If your organization is also one of the many that use Business Objects (BO) as their standard reporting technology, the solution presented below may be for you.
Since version XII, the Business Object Enterprise server is bundled and by default installs the web services module which allows to access reports via SOAP web services. Here's the solution:
- The web application requests a report by calling the special reporting servlet, passing to it the report ID and required parameters.
- The servlet uses web services to login to BO server and request the report, which then is returned to the client and displayed in a new browser tab or window in Acrobat Reader.
Reporting Servlet
The servlet consists of the following modules:
- login module (login to BO server)
- report parms module (requests a list of the parameters required by the report and prepares them)
- report viewer module (configures the request to return the report in PDF format)
- retrieve and deliver module (requests the report from BO server and sends it on its way back to the client)
SessionSoap session = new SessionSoapProxy("http://crystalbo:8080/dswsbobje/services/session");
EnterpriseCredential credents = new EnterpriseCredential();
credents.setLogin(businObjectsLoginName);
credents.setPassword(businObjectsLoginPwd);
SessionInfo si = session.login(credents);
if( si == null ) { login failed... }
// Instantiate Report Engine
ReportEngineSoap rptEngine = new ReportEngineSoapProxy();
No comments:
Post a Comment