Crystal Reports - 在两个日期之间获取数据 [英] Crystal Reports - Get data between two dates
问题描述
亲爱的专家..
我是crystal report开发的新手。我想知道如何从两个日期之间获取数据。我有一个文本框,从日期和到期日在FrmDate(表格)。并为一个clicke事件放一个按钮。如果我将两个不同的日期分配到两个texbox然后单击该按钮我的报告仅显示那些日期之间的数据。请帮助我..
DB是sqlserver2005
先谢谢。
Sreeni
Dear Experts..
I am new in crystal Report development. I want to know that how to get the data from between two dates. I am having Two Textboxes for from date and To date in a FrmDate(Form). and put one button for clicke event. if i am give the two different date into two texbox and then click that button my report showing the data between that dates only. kindly help to me..
DB is sqlserver2005
Thanks in Advance.
Sreeni
推荐答案
从中选择*
TableName t
WHERE CONVERT(Date,t.Fromdate,10)> = CONVERT(Date,@ FromDate,10)
和
CONVERT(日期,t.ToDate,10)< = CONVERT(日期,@ ToDate,10)
如果满足您的需求,请接受此解决方案
Select * from
TableName t
WHERE CONVERT(Date,t.Fromdate,10) >= CONVERT(Date,@FromDate,10)
and
CONVERT(Date,t.ToDate,10) <= CONVERT(Date,@ToDate,10)
Please accept this solution if its fulfill your needs
首先,请勿使用文本框:使用Calendar控件或DateTimePicker。文本框意味着用户输入他们想要的内容,这可能不是有效日期(甚至接近有效日期)。 otehr控件只让他们选择正确的日期,并保存你必须验证它们。
然后,只需使用SQL SELECT:
First off, don't use text boxes: use a Calendar control or a DateTimePicker instead. Textboxes mean that users enter what they want, which may not be a valid date (or even close to a valid date). The otehr controls only let them select "proper" dates, and save you having to validate them.
Then, just use an SQL SELECT:
SELECT * FROM MyTable WHERE MyDateColumn BETWEEN @StartDate AND @EndDate
通过参数化查询填写日期,并直接从控件传递DateTime对象。
Fill in the dates via a parametrised query, and pass the DateTime objects from the controls directly.
这篇关于Crystal Reports - 在两个日期之间获取数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!