i am using crystal report for visual studio 2022
mysql-connector-odbc-8.0.33-winx64.msi
The issue is that no matter what I did to change the date format in Crystal Report, it still displays as follows: 02-May-2023 12:00:00AM,while it should show it like this 02-May-2023. Note field format in database is Date.
if field format in database datetime i can change the format with no problems.
how to solve this issue?