Hi,
I have written the following code to get the scheduled report parameter details in BO xi 3.1
<%@ page import="com.crystaldecisions.enterprise.ocaframework.ServiceNames"%>
<%@ page import="com.crystaldecisions.sdk.exception.SDKException"%>
<%@ page import="com.crystaldecisions.sdk.occa.infostore.*"%>
<%@ page import="com.crystaldecisions.sdk.occa.pluginmgr.*"%>
<%@ page import="com.crystaldecisions.sdk.plugin.CeProgID"%>
<%@ page import="com.crystaldecisions.sdk.plugin.desktop.common.*"%>
<%@ page import="com.crystaldecisions.sdk.plugin.desktop.report.*"%>
<%@ page import="com.crystaldecisions.sdk.plugin.desktop.user.*"%>
<%@ page import="com.crystaldecisions.sdk.properties.*"%>
<%@ page import="com.crystaldecisions.sdk.framework.CrystalEnterprise" %>
<%@ page import="com.crystaldecisions.sdk.framework.IEnterpriseSession" %>
<%@ page import="com.crystaldecisions.sdk.framework.ISessionMgr" %>
<%@ page import="com.crystaldecisions.sdk.occa.infostore.IInfoStore" %>
<%@ page import="com.crystaldecisions.sdk.occa.managedreports.*" %>
<%@ page import="com.crystaldecisions.sdk.occa.security.ILogonTokenMgr" %>
<%@ page import="javax.servlet.http.Cookie" %>
<%
IEnterpriseSession boIEnterpriseSession;
IInfoStore boInfoStore;
String user = "user";
String password = "pwd";
String cmsName = "server";
String cmsAuthType = "secEnterprise";
IInfoObjects boInfoObjects;
IInfoObject boReportObject;
boIEnterpriseSession = CrystalEnterprise.getSessionMgr().logon(user, password, cmsName, cmsAuthType);
try
{
//get the infostore object
boInfoStore = (IInfoStore)boIEnterpriseSession.getService("", "InfoStore");
//query for the report we want to delete
boInfoObjects = boInfoStore.query("select * from ci_infoobjects where si_id =13678231");
int iSize = boInfoObjects.size();
for (int i = 0; i < iSize; i++)
{
//get the report object for deletion
boReportObject = (IInfoObject)boInfoObjects.get(i);
out.println(((IReport)boReportObject).getReportParameters().size());
out.println("<br>");
}
return;
}
catch (SDKException sdkEx)
{
out.println("Deletion Failed <br>");
//out.println(sdkEx.toString());
}
%>
I am getting the followling error
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 22 in the jsp file: /Schedule-Param.jsp
Generated servlet error:
IReport cannot be resolved to a type
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 22 in the jsp file: /Schedule-Param.jsp
Generated servlet error:
IReport cannot be resolved to a type
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:328)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:414)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:297)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:276)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:264)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:563)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:305)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
Kindly help me in resolving the issue.
Thanks,
Subbu S.