Solved

How to pass more than one parameter to crystal reports from Java?

Posted on 2008-10-03
1
1,121 Views
Last Modified: 2013-12-29
I have a JSP that can call a crystal report. This report requires one parameter. See the attached code snippet. Currently this code works fine and can display the report properly. But now I have modified the report to take in 2 parameters. So now I've added the following code after "numberParamField.setCurrentValues(numberValues);"

// logonUserId
String logonUserId = "5"
Integer numberValue2 = new Integer(logonUserId);
ParameterFieldDiscreteValue numParameterFieldDiscreteValue2 = new ParameterFieldDiscreteValue();
numParameterFieldDiscreteValue2.setValue(numberValue2);
Values numberValues2 = new Values();
numberValues2.add(numParameterFieldDiscreteValue2);
ParameterField numberParamField2 = new ParameterField();
numberParamField2.setName("logonUserId");
numberParamField2.setCurrentValues(numberValues2);

And after "parameterFields.add(numberParamField);" I added:

parameterFields.add(numberParamField2);

When I ran the JSP I get a "Some parameters are missing values" error message. How do I pass more than one parameter to the crystal report from Java?

Java Reporting Component API Reference:
http://devlibrary.businessobjects.com/BusinessObjectsXI/en/en/JRC_SDK/jrc_java_api_doc/doc/jrcsdk_java_apiRef/index.html
<%@ page import="com.crystaldecisions.report.web.viewer.*" %>

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

<%@ page import="com.crystaldecisions.reports.reportengineinterface.JPEReportSourceFactory" %>

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

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

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

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

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

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

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

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

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

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

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

<%

//String report = request.getParameter("reportName") + ".rpt";

String report = "web/pages/report/CrystalReport1.rpt";

String matchId = request.getParameter("matchId");

IReportSourceFactory2 rptSrcFactory = new JPEReportSourceFactory();

IReportSource reportSource = (IReportSource)

rptSrcFactory.createReportSource(report, request.getLocale());

ConnectionInfos connInfos = new ConnectionInfos();

IConnectionInfo connInfo1 = new ConnectionInfo();

connInfo1.setUserName("sa");

connInfo1.setPassword("12qwaszx");

connInfos.add(connInfo1);

CrystalReportViewer viewer = new CrystalReportViewer();

viewer.refresh();

viewer.setReportSource(reportSource);
 

// matchId 

Integer numberValue = new Integer(matchId);

ParameterFieldDiscreteValue numParameterFieldDiscreteValue = new ParameterFieldDiscreteValue();

numParameterFieldDiscreteValue.setValue(numberValue);

Values numberValues = new Values();

numberValues.add(numParameterFieldDiscreteValue);

ParameterField numberParamField = new ParameterField();

numberParamField.setName("matchId");

numberParamField.setCurrentValues(numberValues);
 

Fields parameterFields = new Fields();

parameterFields.add(numberParamField);

viewer.setEnableParameterPrompt(false);

viewer.setParameterFields(parameterFields);

viewer.setDatabaseLogonInfos(connInfos);

viewer.setEnableLogonPrompt(false);

viewer.processHttpRequest(request, response,

getServletConfig().getServletContext(), out);

viewer.dispose();

%>

Open in new window

0
Comment
Question by:killdurst
1 Comment
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 22636538
Here are some sample programs to call reports.
There is one that shows how to pass several parameters

https://smpdl.sap-ag.de/~sapidp/012002523100006008962008E/crxi_jrc_jsp_smpl.zip

mlmcc
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
Introduction Java can be integrated with native programs using an interface called JNI(Java Native Interface). Native programs are programs which can directly run on the processor. JNI is simply a naming and calling convention so that the JVM (Java…
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now