Joined: 17 Jul 2017
Location: United States
Online Status: Offline
Posts: 3
Topic: Decimal Values being Dropped Posted: 18 Jul 2017 at 5:34am
Need some help
When creating a new Report the Decimal Values (places) are being Dropped - Not Truncated - Just Dropped.
The Data is being extracted from a ISeries System. The connection is via a Client Access ODBC Connection (Driver) and in Crystal a connection of OLE (ADO)/Microsoft OLE DP Provider for ODBC Drivers.
The strange thing - A Report created under Crystal Reports 9 being run under Crystal 2011 - No Issues. A Report Created under Version 9 and converted to Version 2011 - No Issues. A new report created under Version 2011 - The decimal places are dropped.
Has anyone run up against this and what was the resolution?
Joined: 17 Jul 2017
Location: United States
Online Status: Offline
Posts: 3
Posted: 19 Jul 2017 at 4:18am
Thanks for the information. I did try several different variations of settings within VIEWS and the ODBC Connection with no luck before post my Issue on the FORUM.
I think I may have resolved my Issue by creating a new type of connection within Crystal
Under OLEDB (ADO) - Select - IBM DB2 for i IBMDASQL OLE DB Provider. There is a downside though - There is no presentation of Files to Choose from. A SQL Query needs to be created in order to see the selection of fields.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 19 Jul 2017 at 12:11pm
Okay, definitely looks like a database connection issue. I do not know if current ODBC driver for IBM DB2 works well with Crystal or not. We prefer to a command for most of our reports. Puts most of the processing on the server and we can be more creative in bringing in data.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum