I am running Windows 2K pro with IIS running locally. I am trying to use
record selection formulas when launching the Crystal Viewer control. If
I don't use selection formulas, my report launches fine. At first, I
thought it was just the way I was referencing a field on my form. When I
try to hard code any record selection formula, I still get the error. If
I set up my report to connect directly with the database in the "Set
Location" area of the report, after publishing and launching the report
I will get the error: " Error Occurred Reading Records-File Not Found".
The report file is in the same directory as my Web server. In Crystal, the
connection is directly to the database (No DSN):
session("oRpt").RecordSelectionFormula = CStr("{Employee.EmployeeId} > 1
and {Employee.EmployeeId} < 4")
Im using the SimpleSelectionFormula.asp example downloaded from Crystal.
My database is configured the same as the example, I just replaced the
report name with mine. Any suggestions appreciated. Thanks - Frank