如何在水晶报表vb.net中获取sql查询 [英] How to get sql query in crystal report vb.net

问题描述

这是我的查询

this is my query

select distinct
E.USERID, U.EmployeeName,
Convert(date,LOCALTIMESTAMP) as ATTDate,
(select min(Convert(TIME,TIMESTAMPS)) from access_event_logs As MINCE where CAST(MINCE.TIMESTAMPS as DATE)=CAST(E.TIMESTAMPS As DATE) AND MINCE.EVENTID ='In' and MINCE.USERID=E.USERID) as InTime,
(select max(Convert(TIME,TIMESTAMPS)) from access_event_logs As MAXCE where CAST(MAXCE.TIMESTAMPS as DATE)=CAST(E.TIMESTAMPS As DATE) AND MAXCE.EVENTID ='Out' and MAXCE.USERID=E.USERID) as OutTime
,(select DATEDIFF(MINUTE, '8:30:00', (select min(Convert(TIME,TIMESTAMPS)) from access_event_logs As MINCE2 where CAST(MINCE2.TIMESTAMPS as DATE)=CAST(E.TIMESTAMPS As DATE) AND MINCE2.EVENTID ='In' and MINCE2.USERID=E.USERID))) as LateTime
,(select DATEDIFF(MINUTE, (select max(Convert(TIME,TIMESTAMPS)) from access_event_logs As MAXCE where CAST(MAXCE.TIMESTAMPS as DATE)=CAST(E.TIMESTAMPS As DATE) AND MAXCE.EVENTID ='Out' and MAXCE.USERID=E.USERID), '14:30')) as EarlyTime
from access_event_logs As E
Inner join EmployeeRegistration as U on E.userid = U.userid
WHERE E.USERID='002' AND Convert(date,LOCALTIMESTAMP) between '03/2/2014' and '03/16/2014'

如何在vb.net上获取报告...



iam使用另一个表eventlog ....这个表eventid列创建行（进出）...

这个查询......



如何在vb.net上调用....我想要员工迟到报告

how to get report in vb.net...

iam using another table eventlog.... this table eventid columns create rows (in and out)...
this query...

how to cal on vb.net.... i want employee late report

推荐答案

hi Akhil：



查看此页面，这里是非常简单直接的Crystal存储过程报告



存储过程中的Crystal报告 [ ^ ]

hi Akhil:

Check this page, here is very simple and straight Crystal report with Stored Procedure

Stored Proc In Crystal Report[^]

1.首先设置odbc Connecton然后打开新报告，然后选择ODBC连接和相应字段（例如：USERID，EmployeeName）



2.Go水晶报告中的数据库菜单>显示Sql查询>把你的问题放在那里



另一种方法是创建一个SP

并加入水晶报告

1.First you set up the the odbc Connecton and then open new report ,then select the ODBC connection and Corresponding fields (eg:USERID, EmployeeName)

2.Go Database menu in crystal reports > Show Sql Query > put your query there

another method is create an SP
and add to crystal report

这篇关于如何在水晶报表vb.net中获取sql查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！