Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Re: Crystal Viewer Record Selection Problem


Message #1 by fpy@p... on Sun, 2 Feb 2003 14:46:28
>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

  Return to Index