Parameter setup exception -- Only report parameters can be optional

[Former Member]

Friends,

I'm working with RAS SDK to refresh a crystal report. while parameter setup i'm facing this particular exception.Can anyone help?

com.crystaldecisions.sdk.occa.report.lib.ReportSDKParameterFieldException: Only report parameters can be optional.---- Error code:-2147213303 Error code name:invalidParameterField

at com.crystaldecisions.sdk.occa.report.lib.ReportSDKParameterFieldException.throwReportSDKParameterFieldException(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.ParameterFieldController.for(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.ParameterFieldController.modify(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.ParameterFieldController.modify(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.ParameterFieldController.setCurrentValues(Unknown Source)

at com.crystaldecisions.sdk.occa.report.application.ParameterFieldController.setCurrentValue(Unknown Source)

at reportviewer.Check_Adhoc_Position_Report_Advanced_Report.Report_Connection_Adhoc_Parameters(Check_Adhoc_Position_Report_Advanced_Report.java:204)

at reportviewer.Check_Adhoc_Position_Report_Advanced_Report.main(Check_Adhoc_Position_Report_Advanced_Report.java:57)

Thanks,

Bharath

[Former Member · Accepted solution]

Hi Bharath,

Please let us know the BO product version you are using. Are the reports managed or unmanaged?

Code snippet where you get the error. As per the error message it seems your are not passing the parameters correctly.

Thanks,

Prithvi

[Former Member · Accepted solution]

Prithvi,

Below are the info.

Product version - BO XI 3.1

Reports - Unmanaged

Code snippet

ParameterFieldController paramFieldController = reportClientDoc.getDataDefController().getParameterFieldController();

paramFieldController.setCurrentValue( " ", "Security_Number", "");

Parameter is of string type. Let me know in case of any Queries.

Thanks in Advance,

Bharath

[Former Member · Accepted solution]

Is the Security_Number parameter an optional parameter?

Pass a value to the paramter from code and check the behaviour.

Thanks,

Prithvi

[Former Member · Accepted solution]

Yes Prithvi ,

Security_Number is an optional parameter.

I tried by sending values both String "1234" , Number 1234 , Empty string "" , Space " " and Even null value.

I get same exception for all the try.

Any ideas?

Thanks,

Bharath

[Former Member · Accepted solution]

Can you please run the below snippet and get the details.

===============================

Fields paramFields=rcd.getDataDefController().getDataDefinition().getParameterFields();

for(int i=0;i<paramFields.size();i++)

{

IParameterField paramField=(IParameterField)paramFields.get(i);

String paramName=paramField.getName();

if(paramName.equals("Security_Number"))

{

out.println("<BR>Is Optional Prompt"+paramField.getIsOptionalPrompt());

ParameterFieldType parameterType=paramField.getParameterType();

out.println("<BR>Param Type int value"+parameterType.value());

out.println("<BR>Param Type String value"+parameterType.toString());

}

=========================================

Would need to check the type of the parameter, as stated in the error, only report parameters can be optional.

Please run the test and share the results to narrow down the issue.

Also check the behaviour on the report from crystal report desgner as well.

Thanks,

Prithvi

[Former Member · Accepted solution]

Prithvi,

Below are the info i got regarding Parameter

Is Optional Prompt                true

Param Type int value           1

Param Type String value      StoredProcedureParameter

Thanks,

Bharath

[Former Member · Accepted solution]

Prithvi,

I think i got it. I changed the parameter to Mandatory . Its working fine.

I suppose it happens because the report is linked with a subreport created on a Stored Procedure

andso it appears as StoredProcedureParameter

Any idea to handle this situation without changing parameter to Mandatory?

Thanks,

Bharath

[Former Member · Accepted solution]

I am checking on that. As per the error message the SDK supports only optional paramters for report parameters. I do not have an environment currently to check, however would try if there is an option to have stored procedure parameters as optional.

Thanks,

Prithvi

[Former Member · Accepted solution]

Sure Prithvi. Thanks a lot!