时间数据类型未在Crystal Report VS2010中显示 [英] Time datatype not showing in the Crystal Report VS2010

问题描述

关于在Visual Studio 2010上捆绑的Crystal Report，我有一个奇怪的问题。
我试图创建一个报告，该报告是每日时间记录（TeacherID，日期，时间，超时）

但是在我将表包含在Crystal Report数据库专家中之后，所有 TIME 列均未显示。我尝试了几次测试，例如是否在数据库中连接了囊状报告，例如，我尝试将TIME转换为DateTime，然后验证数据库并选择显示Time列（已转换为DateTime）。

Crystal Reports中TeacherDTR的结构

MSSQL Server中的结构

我试图将TimeInAM从Time更改为DateTime
和oppppssss

我为此而疯狂，并花费大量时间

预先感谢您！

解决方案

您的问题是您无法o尽管它们存在于数据库中，但仍可以在Crystal Reports中查看数据库表中的某些列。

遵循链接这可能对您有所帮助。正如该链接讨论的类似问题。

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!

解决方案

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.

这篇关于时间数据类型未在Crystal Report VS2010中显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！