>I am running Windows 2K pro with IIS running locally. I am trying to use
r> ecord selection formulas when launching the Crystal Viewer control. If
I> don't use selection formulas, my report launches fine. At first, I
t> hought it was just the way I was referencing a field on my form. When I
t> ry 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
L> ocation" 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
c> onnection is directly to the database (No DSN):
> session("oRpt").RecordSelectionFormula = CStr("{Employee.EmployeeId} > 1
a> nd {Employee.EmployeeId} < 4")
> Im using the SimpleSelectionFormula.asp example downloaded from Crystal.
M> y database is configured the same as the example, I just replaced the
r> eport name with mine. Any suggestions appreciated. Thanks - Frank
----------------------------------------------------------------------
I figured this out. Record selection formula was fine. I placed the
database and the report in the same web folder and it worked like a champ.
Need to troubleshoot DSN type connections for future applications though.
Thanks.
Frank