Search code examples
crystal-reports

Time datatype not showing in the Crystal Report VS2010

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.

enter image description here

Structure of TeacherDTR in Crystal Reports

enter image description here

Structure in MSSQL Server

i tried to change TimeInAM from Time to DateTime and oppppssss

enter image description here

enter image description here

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

Thank you in advance!

Solution

  • 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.