Problems linking two tables via text-fields when Using ADO-Access 1

[ef4070]

I am using CR 8.0, Datasource Access 97, Access via ADO

In the report there are tables with order-details-connection. From the Order table there is a
link to the item-table.The link-field (item-number) is a
character-field.
In the report I print fields from both tables.
The problem: The records printed are wrong (joined). It seems, that for each record in the order-detail all records of the items are printed.
This problem appears both at design-time and if I start the Report from a VB6-application.

The problem does not appear if one of the following actions is set:
- I use instead the ADO-Connection the connection direct via database
(MDB)
or
- the item-Number is a numeric field instead of the character field.
or
- I don't print a field of the linked item-table.

For me it seems that there is a problem with linking tables with character-fields by ADO-Access to the datasource.

 

[synapsevampire]

I would suggest that you create a query in Access that does the join, and use the query as the data source in Crystal anyway, it'll be much faster.

Not sure why you you are using ADO anyway, most use either ODBC or File type connectivity.

I would assume that the query issued via ADO is incorrect, did youpaste in a query, or?

The version is so old, and using another connectivity makes more sense anyway from a performance standpoint that it's probably not worth exploring, change the connectivity, and create a query on Access for optimal performance.

-k

 

[ef4070]

Yes, I know that the version of CR is rather old.
Yes, I solved the problem by creating a view wich provides
the table for the CR-Developement.

We use the ADO-Connection, because our application
is able to run against an ACCESS-Database, SQL-Server and Oracle. So we can use one Report-File and change the Databases on runtime.

But I thank you for the advice, that there is maybe really a Report-Problem and that the performance can be increased by using querys.

Norbert