basic syntax what does it mean

[Cyrus]

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

[jggtz]

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 :

'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

[Cyrus]

how can i set CR to VB syntax

[jggtz]

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

[Ned Pepper]

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.