How to pass a date parameter in Crystal reports

[Lawrence 007]

Hi,

I am using a dataset for my Crystal report. Query: Select * from Orders where Date = @Date

How do I pass that to my Crystal Report. This will be passed with a calander I have on my form with a button to display data.

Thanks for the help.

[dip_developer]

Hi,

I am using a dataset for my Crystal report. Query: Select * from Orders where Date = @Date

How do I pass that to my Crystal Report. This will be passed with a calander I have on my form with a button to display data.

Thanks for the help.

Do u want to Pass Date value as a parameter to the Crystal report.....

Create a Parameter Fields in your report .Name it as Order_Date,set its Value Type to Date.......By right Clicking on "Parameter Fields"-----> "New" option.....

In code behind to set the parameter value the code will be like following.....

Dim oRpt as Myreport
oRpt.SetParameterValue("Order_Date", myDate)

[Lawrence 007]

Thanks dip_developer

I had to get some sleep. Will be trying that now and will let you know what happens.

Lawrence

[Lawrence 007]

dip_developer,

It still runs the report and display's all the data. Not just the data for the day I need.

Any Ideas?

[Lawrence 007]

To all that wants to know, here is the answer.

After a lot of searching this is what I did to make it work:


rpt = New CrystalReport1()
Dim reportPath As String = "C:\Crystalreport1.rpt"
CView.ReportSource = rpt
Dim field1 As ParameterField = Me.CView.ParameterFieldInfo(0)
Dim val1 As ParameterDiscreteValue = New ParameterDiscreteValue
val1.Value = "2/20/2007"
field1.CurrentValues.Add(val1)
rpt.Load(reportPath)

It is VERY important to place the parameter After :

CView.ReportSource = rpt
And before:
rpt.Load(reportPath)

It will not work if you don't do this.

Lawrence