Kevin Tang

Greenhorn

+ Follow

news 2 Posts 1 Threads

since May 10, 2012

Merit badge: grant badges

For More

Cows and Likes

Cows

Total received

In last 30 days

Forums and Threads

Recent posts by Kevin Tang

Cannot pass parameter to Crystal Report

Dear all,

My complete source code and eclipse workspace can be download here:
http://dl.dropbox.com/u/43307712/crDemo_workspace.7z

Anyone know how to pass parameter?

Thank you
Kevin.

12 years ago

JSF

Cannot pass parameter to Crystal Report

I am writing a JSF page to get user input, and pass that input to Crystal Report (Crystal Report for Eclipse 2.0). I don't know why the parameterFields cannot load my parameter. Please help me!!!

My First page:

My second page (result page) for "Show Report 2":

My Beanis:

package crDemo;
import javax.faces.bean.ManagedBean;
import com.crystaldecisions.reports.reportengineinterface.JPEReportSourceFactory;
import com.crystaldecisions.sdk.occa.report.data.Fields;
import com.crystaldecisions.sdk.occa.report.data.ParameterField;
import com.crystaldecisions.sdk.occa.report.data.ParameterFieldDiscreteValue;
import com.crystaldecisions.sdk.occa.report.data.Values;
import com.crystaldecisions.sdk.occa.report.lib.ReportSDKException;
import com.crystaldecisions.sdk.occa.report.reportsource.IReportSourceFactory2;
@ManagedBean
public class ReportBean {
private Object reportSource1 = null;
private Object reportSource2 = null;
private String inputText = "";
private Fields<ParameterField> parameterFields = new Fields<ParameterField>();
public Object getReportSource1() {
return reportSource1;
}
public void setReportSource1(Object reportSource1) {
this.reportSource1 = reportSource1;
}
public Object getReportSource2() {
return reportSource2;
}
public void setReportSource2(Object reportSource2) {
this.reportSource2 = reportSource2;
}
public String getInputText() {
return inputText;
}
public void setInputText(String inputText) {
this.inputText = inputText;
}
public Fields<ParameterField> getParameterFields() {
return parameterFields;
}
public void setParameterFields(Fields<ParameterField> parameterFields) {
this.parameterFields = parameterFields;
}
public String show1() {
try {
// Instantiate the report object
String reportLocation;
reportLocation = "rpt/demo1.rpt";
IReportSourceFactory2 rptSrcFactory = new JPEReportSourceFactory();
reportSource1 = rptSrcFactory.createReportSource(reportLocation, java.util.Locale.getDefault() );
} catch (ReportSDKException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return "rpt1";
}
public String show2() {
try {
// Instantiate the report object
String reportLocation;
reportLocation = "rpt/demo2.rpt";
IReportSourceFactory2 rptSrcFactory = new JPEReportSourceFactory();
reportSource2 = rptSrcFactory.createReportSource(reportLocation, java.util.Locale.getDefault() );
// Clear previous parameter
parameterFields.clear();
//Create a ParameterField object for each field that you wish to set.
ParameterField paramFieldOne = new ParameterField();
//You must set the report name. Set the report name to an empty string if your report does not contain a subreport; otherwise, the report name will be the name of the subreport
paramFieldOne.setReportName("");
//Create a Values object and a ParameterFieldDiscreteValue object for each parameter field you wish to set.
//If a ranged value is being set, a ParameterFieldRangeValue object should be used instead of the discrete value object.
Values valueOne = new Values();
ParameterFieldDiscreteValue paramFieldDVOne = new ParameterFieldDiscreteValue();
//----------- Initialize the parameter fields ----------
//Set the name and value for each parameter field that is added.
//Values for parameter fields are represented by a ParameterFieldDiscreteValue or ParameterFieldRangeValue object.
System.out.println("Input parameter = " + inputText);
paramFieldOne.setName("paramOne"); // "paramOne" is parameter name in my Crystal Report file (demo2.rpt)
paramFieldDVOne.setValue(inputText);
//Add the parameter field values to the Values collection object.
valueOne.add(paramFieldDVOne);
//Set the current Values collection for each parameter field.
paramFieldOne.setCurrentValues(valueOne);
//Add each parameter field to the Fields collection.
//The Fields object is now ready to be used with the viewer.
parameterFields.add(paramFieldOne);
} catch (ReportSDKException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return "rpt2";
}
}

Runtime result:

Enter something and click "Show report 2"

12 years ago

JSF