Skip to Content
0
Former Member
Apr 21, 2014 at 09:35 AM

Filter reports on DateTime does not work

92 Views

Hi,

Hope anybody can help.

After upgrading to Crystal Reports for .NET 4.0 (CRforVS 13_0_0.exe) from Crystal Reports for Visual Studio 2005, the reports cannot filter on datetime Types anymore from Visual Studio. The reports works fine, when parameters are entered through the "Main Report Preview", but when provide from Visual Studio it does not filter.

I have tried to use different ways to send the Start end End value to the report, but with no help. When I filter e.g. on a simple string value on a string type field sending the values works fine. I have tried changing the format of the datatime values send, but all with no luck.

The database looks like this

.....

QueueID varchar(50)

QueueStartAt DateTime

....

Filter in Report looks like this

{EM_T_STATISTICS_SOFTQUEUE.QueueStartAt} in {?StartDate] to {?EndDate]

my Code looks like this:

Dim crParameterValues As New ParameterValues

Dim crParameterDiscreteValue As New ParameterDiscreteValue

Dim crParameterFieldDefinitions As ParameterFieldDefinitions

Dim crParameterFieldDefinition As ParameterFieldDefinition

Dim objRpt As New TVSoftQueueReporter.test

'crParameterDiscreteValue.Value = Format(PeriodeStart, "yyyy-MM-dd 00:00:00")

'crParameterDiscreteValue.Value = Format(PeriodeStart, "dd-MM-yyyy 00:00:00")

crParameterDiscreteValue.Value = PeriodeStart

crParameterFieldDefinitions = objRpt.DataDefinition.ParameterFields

crParameterFieldDefinition = crParameterFieldDefinitions.Item("StartDate")

crParameterValues = crParameterFieldDefinition.CurrentValues

crParameterValues.Clear()

crParameterValues.Add(crParameterDiscreteValue)

crParameterFieldDefinition.ApplyCurrentValues(crParameterValues)

'crParameterDiscreteValue.Value = Format(PeriodeStop, "yyyy-MM-dd 23:59:59")

'crParameterDiscreteValue.Value = Format(PeriodeStop, "dd-MM-yyyy 23:59:59")

crParameterDiscreteValue.Value = PeriodeStop

crParameterFieldDefinitions = objRpt.DataDefinition.ParameterFields

crParameterFieldDefinition = crParameterFieldDefinitions.Item("EndDate")

crParameterValues = crParameterFieldDefinition.CurrentValues

crParameterValues.Clear()

crParameterValues.Add(crParameterDiscreteValue)

crParameterFieldDefinition.ApplyCurrentValues(crParameterValues)

CrystalReportViewer1.ReportSource = objRpt

CrystalReportViewer1.Refresh()

Any idea, could this really be a bug?