Creating Selection Criteria for an Existing CR2008 Report

[Former Member]

I have an Crystal .rpt that works outside of SBO 8.8. It is base in a view (VIEWUNIONVENTASNOTASDETALLE). Before importing in SBO 8.8, I change a parameter that is dynamic into a static one and changed its name according. From Vendedores to Vendedores@SELECT EMPLEADONOMBRE FROM VIEWUNIONVENTASNOTASDETALLE

Once I change the report, in CR2008 I set Add-ins->SAP Businese One > Preview in SAP Business One

I get an error message, in CR2008 which is:

SAP Business One

Value cannot be null

Parameter name: o

any suggestions ?

[Former Member]

Did you use optional parameter and in your record selection, did you use HasValue?

If so, you might want to try with removing the HasValue code in record selection.

I think when you are retrieving records based on primary key, you might get an error within SAP B1 when running the report.

Eg: If you are running a report based on OINV that require invoice Number and Invoice Date, SAP B1 request value to be mandatory entered,. I would think it is the same logic applies here.

Good luck.