ODBC Record Source in a report

[rushdib]

Hi,
How do I use an ODBC Connection string as a record source
property in reports? The ODBC connection is to a SQL Server database.

Thank You,

Rushdi

 

[Lozere]

The quietest way is to attach the remote ODBC table and to build the RecordSource parameter on the attached table.

When you can't, build a query to try the SELECT statement before you use it in your Report - you'll see the records returned.
You have to create an SQL-Direct query.

Once running, either use the query as the RecordSource or copy the SQL string generated in the Record Source parameter.