Example 2 - Set Database Logon with Subreport

The following example is a JSP page that demonstrates how to set the database logon information for a report that uses subreports. After the logon information has been set, the report is displayed.

Note:    For any report used with this tutorial sample, you must have the appropriate JDBC data source configured so that it can be accessed by your application server. The report and database used in this example are not included with the tutorials.

SetDatabaseLogonWithSubreport.jsp

<%@page contentType="text/html"%>

<%@page pageEncoding="UTF-8"%>

<%@page import="com.crystaldecisions.reports.sdk.*" %>

<%@page import="com.crystaldecisions.sdk.occa.report.reportsource.*" %>

<%@page import="com.crystaldecisions.sdk.occa.report.lib.*" %>

<%@page import="com.crystaldecisions.sdk.occa.report.data.*" %>

<%

String reportName = "/CRXI_JRC_DatabaseLogonWithSubreport.rpt";

String userName = "devtech";

String password = "devtech";

ReportClientDocument oReportClientDocument = new ReportClientDocument();

try

{

    oReportClientDocument.open(reportName , 0);

    IReportSource oReportSource = (IReportSource)oReportClientDocument.getReportSource();

    

    ConnectionInfos oConnectionInfos = new ConnectionInfos();

    ConnectionInfo oConnectionInfo = new ConnectionInfo();

    

    oConnectionInfo.setUserName(userName);

    oConnectionInfo.setPassword(password);

    

    oConnectionInfos.add(oConnectionInfo);

    session.setAttribute("connectionInfos", oConnectionInfos);

    session.setAttribute("reportSource", oReportSource);

    response.sendRedirect("CrystalReportViewer.jsp");

}

catch(ReportSDKException e)

{

    out.print(e);

}    

%>

CrystalReportViewer.jsp

<%@page contentType="text/html"%>

<%@page pageEncoding="UTF-8"%>

<%@page import="com.crystaldecisions.report.web.viewer.*"%>

<%@page import="com.crystaldecisions.reports.sdk.*" %>

<%@page import="com.crystaldecisions.sdk.occa.report.reportsource.*" %>

<%

IReportSource reportSource = (IReportSource)session.getAttribute("reportSource");

CrystalReportViewer oCrystalReportViewer = new CrystalReportViewer();

oCrystalReportViewer.setReportSource(reportSource);

oCrystalReportViewer.processHttpRequest(request, response, getServletConfig().getServletContext(), null);

%>



Business Objects
http://www.businessobjects.com/
Support services
http://www.businessobjects.com/services/support/