passing field with no value in the criteria selection in sap b1 to crystal reports

[former_member752985]

I made a custom report in crystal reports that runs a filter with some parameters and an SQL command and it works just fine but when I linked it to sap b1 and tried to pass some empty parameters it says that the fields are obligatory even though it works fine in sap crystal reports

I want to know if it's possible to pass an empty value or is there another method to do it.

[Former Member]

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as the overview provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://www.youtube.com/watch?v=46bt1juWUUM

Keep in mind, when you receive an answer that was helpful to you, accept it as best answer.

Best,

Your SAP Community moderator

[azizelmir]

Hi Hamza,

Please check the attached solution!

Thank you,

Aziz

[former_member752985]

I tried but crystal reports won't let me change optional prompt to true

[staseeb]

Hello elel2000,

You can set Crystal Report parameters as OPTIONAL.

Regards,

Taseeb Saeed

[staseeb]

Hello elel2000,

You can set Crystal Report parameters as OPTIONAL.

Regards,

Taseeb Saeed

[former_member752985]

I tried but crystal reports won't let me change optional prompt to true