Optional parameters in CR when created from Command

[former_member410909]

Hello,

I created a new CR. The parameters where created from the Command window.

Those parameters are, of course, used in the query. I need to have an optional parameter (named Test in my screenshot). If I put a default value (let's say 1900-01-01), the parameters becomes a drop-down in SAP B1. If I leave the field blank, SAP says it's mandatory.

Is it possible to have a real optional parameter in this scenario?

thanks for your time and help

[DellSC]

You can edit command parameters in the Field Explorer after creating them in the command editor. So, I might try setting the default value there instead to see whether it will prevent the drop-down. If it works, the users should see the default value instead of a drop-down when they run the report. However, I've not worked with B1 much, so I'm not certain how it will work from there.

-Dell

[former_member410909]

thanks for the reply. I have already tried that and it has the same behavior in B1. As soon as there is a Default value set, it becomes a drop-down, wathever the data type (string, date, datetime, etc).