The report you requested requires further information

[Former Member]

Hi ,

I am using crystal reports x1 , java 6 and jboss5. I had developed one rpt design file, that file will take one parameter. While running that rpt file from servlet I am getting "The report you requested requires further information" statement and one text field. Once I click on that button after entering that value, it is showing required out put.

My code is placing bellow

ReportClientDocument reportClientDocument = new ReportClientDocument();

CrystalReportViewer viewer = new CrystalReportViewer();

ServletContext cxt = req.getSession().getServletContext();

String fileName = "C:/Documents and Settings/Administrator/Desktop/lib-so/ix_sample2.rpt";

try

{

reportClientDocument.open(fileName, 0);

viewer.refresh();

viewer.setReportSource(reportClientDocument.getReportSource());

databaseController = reportClientDocument.getDatabaseController();

} catch(Exception e) { e.printStackTrace();}

ReportSource reportSource = reportClientDocument.getReportSource();

Fields oFields = new Fields();

ParameterField portfolio = new ParameterField();

portfolio.setName("Portfolio");

Values oValues = new Values();

ParameterFieldDiscreteValue oParameterFieldDiscreteValue = new ParameterFieldDiscreteValue();

oParameterFieldDiscreteValue.setValue(new Integer(16));

oValues.add(oParameterFieldDiscreteValue);

portfolio.setCurrentValues(oValues);

portfolio.setReportName(fileName);

oFields.add(portfolio);

ConnectionInfos connectionInfos =new ConnectionInfos();

connectionInfos.add(connectionInfo);

viewer.setDatabaseLogonInfos(connectionInfos);

viewer.setName("malli");

viewer.setOwnPage(false);

viewer.setEnableParameterPrompt(true);

viewer.setParameterFields(oFields);

try {

viewer.processHttpRequest(req, res, cxt, res.getWriter());

viewer.dispose();

} catch (ReportSDKExceptionBase e) {e.printStackTrace();}

Edited by: mallikarjuna.ch1 on May 18, 2009 8:53 AM

Edited by: mallikarjuna.ch1 on May 18, 2009 8:56 AM

[Former Member · Accepted solution]

Hi,

Please check following points:

1)Are you missing any parameter to set?

2)Set viewer.setEnableParameterPrompt(false).

3)Place the database logon code before setting the parameter code.

Do let me know the results.

Thanks,

Neeraj