I'm just starting to use Crystal Reports 8.5.

I'm using fairly simple code to open the report with a lot of help from:

http://www.craigberntson.com/Articles/kb010.htm

My code starts like this:

loCr = CREATEOBJECT("CrystalRuntime.Application")
loCrRpt = loCr.OpenReport("C:\crystaltest\testreport.rpt")
loCrRpt.recordselectionformula = "{testtable.age} > 20"

A few questions:

1. The report is based on an ODBC connection to a Visual FoxPro database. How do I change the DSN at runtime so that I can connect to, for example Oracle or SQL Server data with the same data structure ?

2. The SQL statement above differs slightly in syntax from VFP, where I would have said "age > 20". Is it possible to use a sql statement in Crystal Reports without specifying the table name ?

3. Although I have done a full install of Crystal Reports 8.5 Developer Edition, I can't find any documentation for the CrystalRuntime.Application object - does documentation exist ?

4. When the above query is run, is the query passed through the ODBC driver or is all of the data retrieved and then filtered by the report ? I notice that there is a property called sqlquerystring, but it appears to contain more than an sql statement, and again I can't find any documentation for it.

Best.

Matt.