Time datatype not showing in the Crystal Report VS

Question

I have a weird problem with regards on Crystal Report bundled at visual studio 2010. I'm trying to create a report which is the daily time record (TeacherID,date, time in, time out)

But after i include the table in the crystal report database expert, All TIME column not showing up. I tried several test if the cystal report is connected in the database for example i try to convert the TIME into DateTime then "Verify database" and oppps the Time columns (which is converted into DateTime) was shown up.

Structure of TeacherDTR in Crystal Reports

Structure in MSSQL Server

i tried to change TimeInAM from Time to DateTime and oppppssss

i'm going crazy for this and spends lots of time

Thank you in advance!

Answer 1

finally i found the answer that works fine to me ..

when setting up the connection to the database i used sql server native client but it was wrong

the right one is Microsoft ole db sql provider for sql server

Answer 2

Your issue is you are unable to see some of the columns in a table in database in crystal reports though they exist in database.

Follow the link this might be helpful to you. As this link discuss the similar problem.