Crosstable with rows from linked SQL and Access tables 
Author Message
 Crosstable with rows from linked SQL and Access tables

Using CR 7.0, I set up a report with a crosstab using SQL tables,
linked with primary/foreign key. The foreign key table contains the
summary and row fields, the primary key table is used to show the
primary key description itself instead of the number value. Works
perfect, but if I try to replace the primary key SQL table with an MS
Access table (identical structure), it will not select the records from
Access whatever way I try. I am accessing Access via DAO, and I have
the impression that CR has problems with the linking between the
tables. I HAVE TO use an external source as this contains texts in a
language not supported by MS SQL and combine it with English. Does
anybody know how to solve this problem? Help is greatly appreciated.

Raymond

Sent via Deja.com http://www.*-*-*.com/
Before you buy.



Wed, 08 Jan 2003 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Access 2000 VBA/SQL - cannot create pseudo-index on linked SQL Server table

2. HELP!!..accessing access 2000 with linked SQL Server tables

3. Linking Access Tables in Different *.mdb Files, Populating an Access Table From Several Others

4. Linking Access Tables in Different *.mdb Files, Populating an Access Table From Several Others

5. DNS less Access Linked tables to SQL Server 2000

6. Question about linking SQL Server Tables in Access 98

7. Saving embedded word 97 docs in Access db with linked SQL Server tables

8. SQL to Access Linked table - Number field type problem

9. SQL Tables Linked to Access DB

10. How to Link a Acess Table to a Access SQL View in CRP 7

11. How to make a LINK Table in SQL 2000 Like MS Access

12. Access + SQL - linked table becomes read-only???

 

 
Powered by phpBB® Forum Software