what 2 do in CrystalReport to accept the value which i am passing from jsp
hi,
I am doing Crystal Report with jsp..using Tomcat 5.x as server...and using CRX1 trial version
how can i pass parameter from jsp to Report(say Empl.rpt)?...what are the steps...
shall i have to do anything in crystal report (Empl.rpt) to accept the value which i am passing from jsp.....can u help me please....
am using this code....
<%@ page import="com.crystaldecisions.report.web.viewer.CrystalReportViewer" %>
<%@ page import="com.crystaldecisions.reports.reportengineinterface.JPEReportSourceFactory" %>
<%@ page import="com.crystaldecisions.sdk.occa.report.reportsource.IReportSourceFactory2" %>
<%@ page import="com.crystaldecisions.sdk.occa.report.reportsource.IReportSource" %>
<%@ page import = "com.crystaldecisions.report.web.viewer.*" %>
<%@ page import = "com.crystaldecisions.sdk.occa.report.data.*" %>
<%
String report="/Empl.rpt";
IReportSourceFactory2 rptSrcFactory= new JPEReportSourceFactory();
IReportSource reportSource=(IReportSource)rptSrcFactory.createReportSource(report,request.getLocale());
Fields fields = new Fields();
ParameterField pfield1 = new ParameterField();
ParameterField pfield2 = new ParameterField();
Values vals1 = new Values();
Values vals2 = new Values();
ParameterFieldDiscreteValue pfieldDV1 = new ParameterFieldDiscreteValue();
pfield1.setReportName("");
pfield1.setName("EMP_ID");
String age=request.getParameter("age");
Integer Age = new Integer(age);
pfieldDV1.setValue(Age);
vals1.add(pfieldDV1);
pfield1.setCurrentValues(vals1);
fields.add(pfield1);
CrystalReportViewer viewer = new CrystalReportViewer();
viewer.setReportSource(reportSource);
viewer.setParameterFields(fields);
viewer.setEnableParameterPrompt(false);
viewer.refresh();
viewer.processHttpRequest(request, response,getServletConfig().getServletContext(), out);
viewer.dispose();
%>
sujith.mohan@gmail.com
pvsm
