Hello all. I'm new to Crystal XI and am trying to connect to a dataset to run some reports from it. The problem is I can connect to the tables but some fields are not present in my Field Explorer.

The connection I am using is called 'OLE DB ADO - Microsoft OLE DB Provider for SQL server' and is connecting to a Microsoft Dynamics NAV system.

The fields that are missing are classed as decimal data type in NAV. However, some other decimal types are appearing as numbers etc.

Is this a problem with Crystal XI not being able to see decimal field types? Or is it something else?

I can't really change the field types in NAV to number (or something like that) as it is a huge system and I am only tasked with reporting from it.

Has anyone got any ideas about how to see the missing fields in Crystal? Any help would be much appreciated.

P.S. I'm using Crystal 11 v 11.0.0.1282 and my connection is direct to the data source using the above SQL provider.

Many thanks for any help in advance. Ben.

Edited by benwsear - 14 Aug 2012 at 5:30am

Usually the OLEDb driver for SQL Server works best, but might want to try to create an ODBC connection to the database and determine whether you can see the fields using that instead of the OLEDb connection.

What version of SQL Server are you connecting to?  IIRC, there were some new field types added to SQL Server in the latest release and Crystal XI is older software that may not recognize the field type.

The provider may include the fields but if Crystal doesn't recognize the field type it won't display them.

I believe that is one of the new field types.  How much control do you have in the database?  How are your SQL skills? Can you create a view?  If so, you could create a view that just returns the data from the table but casts the decimal fields as numbers.  If not and your SQL skills are good, you could create a command (SQL Select statement) in Crystal that will pull all of the data for your report, casting the decimal fields as numbers.