Decimal Values being Dropped
Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22389
Printed Date: 04 May 2024 at 4:47am
Topic: Decimal Values being Dropped
Posted By: jlane2017
Subject: Decimal Values being Dropped
Date 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?
|
Replies:
Posted By: kevlray
Date Posted: 18 Jul 2017 at 9:42am
|
Sounds like a view issue. I do not remember what the default decimal settings are for CR 2011. We are on CR 2013 and have been for a while.
|
Posted By: jlane2017
Date 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.
|
Posted By: kevlray
Date 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.
|
Posted By: jlane2017
Date Posted: 25 Jul 2017 at 3:15am
Thanks again for the assist.
I also find it easier to build a SQL Query and testing it on the iSeries System - Then doing a copy/Paste into Crystal.
|
|