Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Crystal Viewer Record Selection Problem


Message #1 by fpy@p... on Fri, 31 Jan 2003 18:14:57
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


  Return to Index