Suppress three dot ... drop down from Crystal Reports date parameter

[former_member203168]

Could anyone help me to suppress three dot drop down from Date parameter.

we have created this parameter at Add command level

capture.png

[vitaly_izmaylov · Accepted solution]

It is Dynamic Parameter and brings values from the datasource to drop-down menu.

Change the Parameter to Static and you would not see the drop-box.

[former_member203168]

Hi Abhilash,

When I removed Default Value, It is working as expected.

If possible, Could you explain why it is displaying drop down, when it contains a default value?

Thanks,

Praveen G

[DellSC]

Crystal adds the default value from the Command editor to the static list of values for the parameter. So, when you run the report, the parameter thinks it has a list of values.

-Dell

[former_member203168]

Thank you for the clarification Dell 🙂

[abhilash_kumar]

Hi Praveen,

Go to the Command Object > Highlight the Date parameter > Modify.

Remove the Date value under "Default Value".

-Abhilash

[former_member203168]

Hi Vitaly,

Hope you are doing well.

When I checked at report level, it is showing Static parameter. Do you want us to remove parameters from Add Command and create it at report level?

as query fetching huge database, we need parameters at Add Command level.

Please let us know how to create static parameters at Add Command level.

Thanks,

Praveen G