Skip to Content
avatar image
Former Member

missingParameterValueError in Subreport with the Database Field

Hi

we are facing below error when mapping database fields to the Sub report. in main report its working fine. appreciate if any one can advised to resolved the issue.

  • Is there any possible way to find the relevant missingParameter name
com.crystaldecisions.sdk.occa.report.lib.ReportSDKParameterFieldException: InternalFormatterException---- Error code:-2147217394 Error code name:missingParameterValueError
  • By removing below highlighted database field and highlighted code changes from the sub report, Report PDF file is generating with the sub report.

Code Sample

package javaapplication1;


import com.crystaldecisions.sdk.occa.report.application.ISubreportClientDocument;
import com.crystaldecisions.sdk.occa.report.application.ParameterFieldController;
import com.crystaldecisions.sdk.occa.report.application.ReportClientDocument;
import com.crystaldecisions.sdk.occa.report.exportoptions.ReportExportFormat;
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileOutputStream;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.Date;
import java.sql.ResultSet;
import java.sql.Statement;
import oracle.jdbc.OracleTypes;


public class JavaApplication1 {


    public static void main(String[] args) {
        try {
            String report_name = "D:\\report\\Cash_Statement_n.rpt"; //subreport_1.rpt
            String exportFileName = "D:\\report\\Cash_Statement.pdf"; //subreport_1.pdf
            ReportClientDocument clientDoc = new ReportClientDocument();
            clientDoc.open(report_name, ReportExportFormat._PDF);


            OracleConnection o = new OracleConnection();
            Connection conn = o.getOraConn();


            CallableStatement stmt = conn.prepareCall("{call t05_cash_account_log_pkg.cash_statement(?,?,?,?,?)}");


            stmt.registerOutParameter(1, OracleTypes.CURSOR);
            stmt.setInt(2, 11460);
            stmt.setDate(3, Date.valueOf("2013-03-31"));
            stmt.setDate(4, Date.valueOf("2018-01-31"));
            stmt.setInt(5, 2);


            stmt.executeUpdate();


            ResultSet rset;
            rset = (ResultSet) stmt.getObject(1);
            clientDoc.getDatabaseController().setDataSource(rset);


            clientDoc.getDataDefController().getParameterFieldController().setCurrentValue("", "pPeriod", "Welcome to Crystal Reports");
            clientDoc.getDataDefController().getParameterFieldController().setCurrentValue("", "pMubasherNo", "Welcome to Crystal Reports");
            clientDoc.getDataDefController().getParameterFieldController().setCurrentValue("", "pAddress", "Welcome to Crystal Reports");
            clientDoc.getDataDefController().getParameterFieldController().setCurrentValue("", "pDisclaimerEn", "Welcome to Crystal Reports");
            clientDoc.getDataDefController().getParameterFieldController().setCurrentValue("", "pCurrency", "Welcome to Crystal Reports");
            clientDoc.getDataDefController().getParameterFieldController().setCurrentValue("", "pAccountNo", "Welcome to Crystal Reports");


            String subReportQuery = "select t05_id as a from t05_cash_account_log";
            Statement statement = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            ResultSet rs = statement.executeQuery(subReportQuery);


            ISubreportClientDocument subreport = clientDoc.getSubreportController().getSubreport("Subreport");
            String subreportTableAlias = subreport.getDatabaseController().getDatabase().getTables().getTable(0).getAlias();
            subreport.getDatabaseController().setDataSource(rs, subreportTableAlias, subreportTableAlias);


            ParameterFieldController paramFieldController = clientDoc.getDataDefController().getParameterFieldController();
            paramFieldController.setCurrentValue("Subreport", "pMubasherNo", "Test01");
            paramFieldController.setCurrentValue("Subreport", "ptest", "Test02");


            ByteArrayInputStream bais = (ByteArrayInputStream) clientDoc.getPrintOutputController().export(ReportExportFormat.PDF);


            int size = bais.available();
            byte[] barray = new byte[size];
            FileOutputStream fos = new FileOutputStream(new File(exportFileName));
            ByteArrayOutputStream baos = new ByteArrayOutputStream(size);
            int bytes = bais.read(barray, 0, size);
            baos.write(barray, 0, bytes);
            baos.writeTo(fos);
            clientDoc.close();
            bais.close();
            baos.close();
            fos.close();
        } catch (Exception ex) {
            System.out.println(ex);
        }
    }
}
capture.jpg (76.8 kB)
capture2.jpg (74.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers