Crystal Reports 10.2 Error in SelectionFormula???

[blakemckenna]

I have attached the Error Message as a Word Doc so it can be viewed. I'm not sure if the Selection Formula is syntactically correct. I've also included the code that generates the report below:


Public Sub TimeByProject(ByVal intMO As Integer, ByVal intYR As Integer)
Try
strModule = "modReporting"

Dim crDOC As New rptTimeByProject
Dim strSelectionFormula As String = ""

crConnectionInfo = New ConnectionInfo

With crConnectionInfo
.ServerName = "ServerName"
.DatabaseName = "SCTime"
.IntegratedSecurity = True
End With

crDB = crDOC.Database
crTables = crDB.Tables

For Each crTable In crTables
crTableLogOnInfo = crTable.LogOnInfo
crTableLogOnInfo.ConnectionInfo = crConnectionInfo
crTable.ApplyLogOnInfo(crTableLogOnInfo)
Next

frmReports.rptViewer.DisplayGroupTree = False
strSelectionFormula = "month({tblTimeSheetDetail.beginPeriodDate}) = " & intMO & " AND year({tblTimeSheetDetail.beginPeriodDate}) = " & intYR
crDOC.RecordSelectionFormula = strSelectionFormula
frmReports.rptViewer.ReportSource = crDOC
frmReports.ShowDialog()
crDOC = Nothing

crDB = Nothing
crTables = Nothing
crConnectionInfo = Nothing

Catch ex As Exception

End Try
End Sub

[blakemckenna]

any ideas on this???

[brucevde]

Well, based on the error message, Crystal does not recognize that the {tblTimeSheetDetail.beginPeriodDate} field is a Date/Time field.

Check the database. Is it a date/time field or perhaps its a string field that contains date data?

Has the database changed after the report was initially created?

[blakemckenna]

Bruce,

It's a field that contains a date value, however, it's type is not a datetime.

[brucevde]

Then, to use the Month, Year functions you need to convert the field to a datetime data type. You could also use String functions Left, Right, Mid) to parse out the date part values.

month(cdate({tblTimeSheetDetail.beginPeriodDate}))