Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import com.crystaldecisions.sdk.framework.*
- import="com.crystaldecisions.sdk.exception.SDKException
- import="com.crystaldecisions.sdk.occa.infostore.*
- import com.businessobjects.rebean.wi.*
- boolean loginSuccessful = false;
- IEnterpriseSession oEnterpriseSession = null;
- String username = "Administrator";
- String password = "MyPassword";
- String cmsname = "localhost";
- String authenticationType = "secEnterprise";
- try {
- //Log in.
- oEnterpriseSession = CrystalEnterprise.getSessionMgr().logon( username, password, cmsname,authenticationType);
- if (oEnterpriseSession == null) {
- } else {
- loginSuccessful = true;
- }
- } catch (SDKException sdkEx) {
- }
- if (loginSuccessful) {
- IInfoObject oInfoObject = null;
- String docname = "TestWebi";
- //Grab the InfoStore from the httpsession
- IInfoStore oInfoStore = (IInfoStore) oEnterpriseSession.getService("", "InfoStore");
- //Query for the report object in the CMS. See the Developer Reference guide for more information the query language.
- String query = "SELECT TOP 1 * " +"FROM CI_INFOOBJECTS " + "WHERE SI_INSTANCE = 0 And SI_Kind = 'Webi' " +"AND SI_NAME='" + docname + "'";
- IInfoObjects oInfoObjects = (IInfoObjects) oInfoStore.query(query);
- if (oInfoObjects.size() > 0) {
- //Retrieve the latest instance of the report
- oInfoObject = (IInfoObject) oInfoObjects.get(0);
- // Initialize the Report Engine
- ReportEngines oReportEngines = (ReportEngines) oEnterpriseSession.getService("ReportEngines");
- ReportEngine oReportEngine = (ReportEngine) oReportEngines.getService(ReportEngines.ReportEngineType.WI_REPORT_ENGINE);
- // Openning the document
- DocumentInstance oDocumentInstance = oReportEngine.openDocument(oInfoObject.getID());
- DataProvider oDataProvider = null;
- //Loop through dataproviders and purge data
- for (int i=0; i<oDocumentInstance.getDataProviders().getCount(); i++) {
- oDataProvider = oDocumentInstance.getDataProviders().getItem(i);
- oDataProvider.purge();
- // This option purges data as well as reset prompt values used during last refresh
- //oDataProvider.purge(true);
- }
- oDocumentInstance.save();
- oDocumentInstance.closeDocument();
- }
- oEnterpriseSession.logoff();
- }
Add Comment
Please, Sign In to add comment