basic syntax what does it mean

Dim Report As New CrystalReport36
Dim strselectionformula As String
Dim vReconDate As Date
Private Sub Form_Load()
vReconDate = CDate(Daily_Route_Recon.MaskEdBox1(0).Text)
Report.ReportTitle = Daily_Route_Recon.MaskEdBox1(0).Text
Report.DiscardSavedData
strselectionformula = " {DailyRouteReconciliation.RECONDATE} =#" & vReconDate & "#"
Report.RecordSelectionFormula = strselectionformula
Screen.MousePointer = vbHourglass
CRViewer1.ReportSource = Report
CRViewer1.ViewReport
Screen.MousePointer = vbDefault
End Sub

Private Sub Form_Resize()
CRViewer1.Top = 0
CRViewer1.Left = 0
CRViewer1.Height = ScaleHeight
CRViewer1.Width = ScaleWidth

End Sub

this is the result.....

"BASIC SYSNTAX IS NOT SUPPORTED IN GROUP OR RECORD SELECTION FORMULA"

any suggestions ?

thnks
cyrus

It means that you can set 2 kind of formulaes syntax in CR : CR syntax or VB syntax
Then, You have to supply the formula using CR syntax
There are several ways to do it, here's one :

Code:

---

'Variables already declared as integer
MyM = Month(vReconDate)
MyD = Day(vReconDate)
MyY = Year(vReconDate)

strselectionformula = "{DailyRouteReconciliation.RECONDATE} =Date(" & Format(MyY) & "," & Format(MyM) & "," & Format(MyD) & ")"

---

Or set the CR report to use VB syntax and use VB syntax

how can i set CR to VB syntax

You didn't say CR version, but in CR 10 you can set Formula Language in
Menu/File/Options/Reporting/Formula Language
Could be Crystal syntax or Basic syntax

No matter how you set the formula languge, the record selection and group selection formulae must be in Crsytal Syntax. Basic syntax is not supported for these two formulae.