Error in Crystal call B1if with native ORDR layout

[Former Member]

Hi xperts,

Im getting this error when I pass parameters to a Crystal reports atom:

com.crystaldecision.sdk.occa.report.lib.ReportSDKException: Invalid argument---- Error code:-2147467259 Error code name:failed

This is my code:

This issue only appears when i use the SAP Business One native layout, i create a new layout with the same parameters and works fine.

Does anybody knows whats wrong?

[Former Member · Accepted solution]

Hi everyone I upgrade my version to pl15 and solve my problem is a application error and you can see it in the pl15 solutions thanks anyway

[Former Member]

I made some changes and know I get this error:

and my code seems like this:

please need your help

Best Regards

[former_member203816]

Hi David,

I am also facing the same issued.

Thanks,

Tushar

[bastian_schaefer]

Hi,

according to the crystal atom documentation the parameters need to be duplicated.

The following payload is used to print a sales order using the standard print template:

<Payload id="atom2" Role="X">
<parameters xmlns="">
<parameter type="double" name="@DocKey@" parameterInDB="true" v2="" v1="460"/>
<parameter type="double" name="DocKey@" v2="" v1="460"/>
<parameter type="double" name="@ObjectId@" parameterInDB="true" v2="" v1="17"/>
<parameter type="double" name="ObjectId@" v2="" v1="17"/>
</parameters>
</Payload>

My crystal scenario step looks as follows:

• atom6: SQL statement to retrieve the template
• atom3: xsl transformation prepare the report params according to the template
• atom4: java call using the template as  inbound to retrieve the parameters
• atom7: xsl transformation to copy template from atom6 into image used in crystal reports atom
• atom2: xsl transformation to prepare the parameters retrieved by java class for usage in crystal reports atom
• atom1: crystal reports atom, using atom7 (image) and atom2 (parameters)

The following screenshot shows the preparation for the crystal reports call, relevant are atom7 and atom2:

Best regards

Bastian

[Former Member]

Sorry forgot my code:

Best Regards!!

David Almazán