Crystal Report中的日期参数 [英] Date Parameter in Crystal Report

问题描述

先生，
您知道如何在两个日期之间过滤数据.我的表单中有两个datetimepicker，还有一个水晶报表查看器，我想用两个datetimepicker之间的指定日期过滤数据.你能给我一些想法吗?

谢谢...

这是我的代码:

Sir,
Do you know how to filter the data between two dates. I have two datetimepicker in my form and a crystal report viewer I want to filter the data with the specified date between the two datetimepicker. Can you give me some idea.

thanks...

Here is my code:

Private Sub dateButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dateButton.Click
       Dim rpt1 As New ReportDocument
       rpt1.Load("*\myCR1.rpt")


       Dim crParameterFieldDefinitions As ParameterFieldDefinitions
       Dim crParameterFieldDefinition As ParameterFieldDefinition
       Dim crParameterValues As New ParameterValues
       Dim crParameterDiscreteValue As New ParameterDiscreteValue
       Dim crParameterDiscreteValue1 As New ParameterDiscreteValue

       crParameterDiscreteValue.Value = DateTimePicker1.Value
       crParameterDiscreteValue1.Value = DateTimePicker2.Value

       crParameterFieldDefinitions = rpt1.DataDefinition.ParameterFields()

       crParameterFieldDefinition = crParameterFieldDefinitions.Item("DateOrdered" & "DateOrdered1")

       crParameterValues = crParameterFieldDefinition.CurrentValues

       crParameterValues.Clear()
       crParameterValues.Add(crParameterDiscreteValue)
       crParameterFieldDefinition.ApplyCurrentValues(crParameterValues)

       iansCRviewer.ReportSource = rpt1
       iansCRviewer.Refresh()
   End Sub

推荐答案

http://csharpdotnetfreak.blogspot.com/2011/09/pass-crystalreport-parameters.html

和

http://www.aspfree.com/c/a/ASP.NET/Working-with-Parameters-with-Crystal-Reports-and-ASP-NET-2-0/

http://csharpdotnetfreak.blogspot.com/2011/09/pass-crystalreport-parameters.html

and

http://www.aspfree.com/c/a/ASP.NET/Working-with-Parameters-with-Crystal-Reports-and-ASP-NET-2-0/

在CodeProject上尝试本文

使用选择参数进行Crystal报表过滤 [在Crystal Report中使用公式 [

Try this Articles on CodeProject

Crystal Report Filtering Using Selection Parameters[^]

Or

Using Formula in Crystal Report[^]

They will help you. It''s quite easy.

Thanks.

这篇关于Crystal Report中的日期参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！