Crystal Reports 2008(v.12) data retrieval problems Nav 3.7

JBeck

Hi there,

I'm new to crystal reports and I'm experiencing a few difficulties.
Hopefully someone can help me.
First I'd like to say that I've checked all the crystal reports posts and I'm still stuck with my problem.

My setup:

Navision: Navision Business Solutions 3.7
ODBC driver installed (installation Disk nav 3.7)
Connection: Server

ODBC connection: System DSN : Option : Commit Cache: yes
DBMS Cache (KB): 100000
Enable BLOB Fields: yes
Identifiers: All Except DOT
Option Field Type: Text
Language: Auto
Query Time-out: No
Query Time-out (sec): EMPTY
Read Only: No
Tmp Path: EMPTY
Closing Date Support: No
Use Regional Decimal Symbol: No

Database: Native

Crystal rpt Connection: OLE DB (ADO) : Microsoft OLE DB Provider for ODBC drivers

My Problem:
I have successfully made a connection and made a test report using only 1 table.
When I try to make a new report with 2 tables e.g. Customer and "Cust. Ledger Entry" using "Cus. ledger entry"."Customer No." and Customer.Name I get the following error on preview:

"Failed to retrieve data from the database"

"Failed to retrieve data from the database
Details: ADO Error Code: 0x
Source Microsoft OLE DB Provider for ODBC Drivers
Destination [Microsoft Business Solution ApS][Microsoft Business Solutions-Navision ODBC Driver] Unexpected extra token: INNER
SQL State: 37000
Native Error: [Database Vendor Code: 1017]"

In this e.g. I've only made a link with "Cust. Ledger Entry"."Customer No." and Customer."No."
I've also made a Crystal rpt conn. using ODBC (RDO). This was also a failure (couldnt even make a report using 1 table).

Can someone tell me what I'm doing wrong?
Please advise.

Thanks in advance,
JBeck

ara3n

ODBC connection is poorly supported.
One suggestion is to move to sql.

Another is to create an access table. Create linked table for each table in NAV through ODBC, and they use crystal report to query the access database.

Savatage

have you tried using

ODBC (RDO) instead of OLE DB (ADO) ?

Toutatis

As someone posted above..

"Another is to create an access table. Create linked table for each table in NAV through ODBC, and then use crystal report to query the access database."

This is what worked for me when I was looking after V3.7 databases.. it's not exactly the most robust solution in the world, but I could find no other way around it at the time. ](*,)

JBeck

I've also made a Crystal rpt conn. using ODBC (RDO). This was also a failure (couldnt even make a report using 1 table).

Yes I've also tried connecting through ODBC (RDO).