Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crystal in B1 8.8 - optional parameters not working

I have defined a business partner parameter

Name is

Customers@SELECT cardcode, cardname FROM OCRD WHERE Cardtype = 'C'

Flagged as optional and allow range

Used in record selection as follows

(not HasValue({?Customers@SELECT cardcode, cardname FROM OCRD WHERE Cardtype = 'C'}) OR {OCRD.CardCode} = {?Customers@SELECT cardcode, cardname FROM OCRD WHERE Cardtype = 'C'})

When running in the designer, if no values entered then all business partners selected as expected.

When running through B1 if no values are entered then no records are selected rathr than all records. Works OK if start or end ranges or both are supplied. Eg. Start only gets all customers from that code to end and end only gets all customers before that code.

Any ideas on how to make it completely optional?

Is there an issue with HASVALUE?

Former Member
Not what you were looking for? View more on this topic or Ask a question