Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
grgimpy
Starting Member
3 Posts |
 Posted - 2009-04-10 : 12:44:02
|
| I am in the process of migrating former Access tables into SQL server, then using the original Access frontend databases to access the information. So far, it has been pretty smooth besides some issues with my Pivotcharts.For some reason, many of my Pivotcharts are rounding down the data points to the nearest integer value instead of displaying in decimal form. When i open the Pivotchart form in Datasheet view, all the information appears normally with no rounding.For example a dataset of {10.71, 11.21, 9.66, 8.99} shows up as {10, 11, 9, 8} when graphed in the Pivotchart.Has anyone else run into this problem? I swear these Pivotcharts always find new ways to screw with me! Thanks for any suggestions. |
|
|
grgimpy
Starting Member
3 Posts |
Posted - 2009-04-10 : 13:04:13
|
| I've determined that the problem has something to do with changing my number data types to decimal from double if that helps at all. |
 |
|
|
grgimpy
Starting Member
3 Posts |
Posted - 2009-04-10 : 15:39:44
|
| Well, I found a fix, but still don't understand what the issue is. I used the CDbl() function in my queries for each Pivotchart and that fixed the problem. Not sure why the Decimal datatype messes it up still.... |
|
|
|
|
|
|
Access PivotCharts Linked to SQL Server