How can i switch the database on my report from Btrieve to SQl?

[antivirus22]

My report uses one table and currently uses Btrieve Database. We switched over to SQL and that same table with the same #of columns and field sizes is in SQL. How can i simply keep the report format but switch the Database to MS-SQL?

 

[bdreed35]

Open the report.
Choose Database, Set Location.
Click the Set Location button.
Expand ODBC.
Select "Create New Datasource"
Create the ODBC datasource using the wizard.
After your done with the wizard, you should see it in the list under ODBC.
Expand the ODBC name, then navigate to the new table, highlight it and click SET.
It should give you the option to propagate the remaining objects.
Run and test it.

~Brian

 

[antivirus22]

When I got to SET LOCATION in Crystal. I see the actual path of the btrieve table im using, i do not see where to change the ODBC Source, and navigate to new table

 

[dgillz]

Create the new datasource manually from control panel, administrative tools, ODBC data sources. Then set the location from within Crystal.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com