When I try to show some of my reports a blank window pops up and I get a Runtime error 20527, SQL Server Error. Is there something in crystal reports that's causing my problem?
Here's the code that I'm using in vb:
pstrUserDate1 = InputBox("Enter the start date in the format MM-DD-YYYY:", "Report")
pstrUserDate2 = InputBox("Enter the end date in the format MM-DD-YYYY:", "Report")

crp.Formulas(0) = ""
crp.Formulas(0) = "UserDate='" & pstrUserDate1 & _
" Thru " & pstrUserDate2 & "'"

crp.SelectionFormula = _
"{Table.DATE_TIME} >= '" & pstrUserDate1 & "' AND " & _
"{Table.DATE_TIME} <= '" & pstrUserDate2 & "'"

crp.ReportFileName = ("g:\reports\report.rpt")
crp.Connect = "DSN=test;PWD=;"
crp.Action = 0