Failed to retrieve initial report values
I got following error when i access report through RAS (from my machine).
Error:
Failed to retrieve initial report values. For example, the database information for this report could be incomplete or incorrect. This is a configuration problem. Please contact your system administrator.
on the otherhand when i access same report on Crystal Report Server (on that machine where Crystal Report Server Installed) no issue raised, report successfully open.
also that problem only raised when my report point to oracle server, else no issue raised on both side.i tried report which point to SQL Server, no issue raised.
shows code snippet below
{
HttpSession session = request.getSession();
IEnterpriseSession enterpriseSession;
ISessionMgr mySessionMgr = CrystalEnterprise.getSessionMgr();
enterpriseSession = mySessionMgr.logon("Admin","","myserver:6400","sec Enterprise");
// This is the part that will let you bypass the logon.aspx - the attribute has to be named CE_ENTERPRISESESSION.
session.setAttribute("CE_ENTERPRISESESSION", enterpriseSession);
IInfoStore iStore = (IInfoStore) enterpriseSession.getService("InfoStore");
IInfoObjects reports = iStore.query("Select SI_ID From CI_INFOOBJECTS Where SI_NAME='TestOrclRpt' And SI_INSTANCE=0");
IInfoObject report = (IInfoObject)reports.get(0);
IReportAppFactory reportAppFactory = (IReportAppFactory) enterpriseSession.getService("RASReportFactory");
ReportClientDocument rcd = new ReportClientDocument();
viewer.setReportSource(rcd.getReportSource());
viewer.setOwnPage(true);
viewer.setOwnForm(true);
viewer.setEnableLogonPrompt(false);
viewer.setEnableParameterPrompt(false);
viewer.setHasRefreshButton(false);
viewer.setHasLogo(false);
viewer.setHasPageBottomToolbar(false);
viewer.processHttpRequest(request, response, getServletConfig().getServletContext(),null);
viewer.dispose();
}
please guide me what i was doing wrong,any help regarding would be appreciated
Thanks in Advance
|
