Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Crystal Reports connection missing table fields
benwsear
Member Posts: 2
Hello all. I'm new to Crystal XI and Nav 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 Crystal 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. For instance, in our Cust_Ledg table we have a decimal type field called Original Amount. Crystal simply will not show this field even though it shows about 80% of the table fields.
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. I've downloaded a trial version of Crystal 2011 (as I thought XI was out of date with SQL fields), but still get no joy.
Many thanks for any help in advance. Ben.
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. For instance, in our Cust_Ledg table we have a decimal type field called Original Amount. Crystal simply will not show this field even though it shows about 80% of the table fields.
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. I've downloaded a trial version of Crystal 2011 (as I thought XI was out of date with SQL fields), but still get no joy.
Many thanks for any help in advance. Ben.
0