Date field not showing

[Former Member]

Hello.

I am trying to run reports via ODBC connection to a MariaDB using Crystal 2016 and I am unable to see date fields in my report. I can pull in all other fields and they are readable but dates don't show. I know there is data in the fields as I can view the data on the application front-end and in reports using MySQL, just not in Crystal. Do you know why this is behaving in the manner and how to solution for it? I’ve attached a screen grab. Thanks in advance.

[Former Member · Accepted solution]

Do you have a query tool for MariaDB.

Copy SQL from Crystal( Menu - Report-Show SQL) and try running and see if data is returned.

Try changing connection to OLEDB if possible

Ian

[Former Member]

All hail Ian for he is the fairest in the land!

Your suggestion to use the OLE DB connection worked. Never have I been so relieved and excited about seeing data. Thanks so much for your time and effort. Its very appreciated.

[Former Member]

Hi Ian. Thanks for your response.

When I browse the field there's nothing, and the totext suggestion returns blanks. Count and distinct count also returns nothing.

[Former Member]

If you go Field explorer and right click Date filed and select Browse do you see data there?

If yes it might be a formatting issue?

Try creating a formula and use totext(your datefield) place this on report and see if that displays any data

Ian