Hello:
I have a custom SharePoint list which contains a column that is of type numeric. I am placing a very large value into the column ($123,456,789,012). When I use the data extension to access this number from within SSRS, I do not get the full precision of the column. With the example above, I only get part of the answer in SSRS ($123,456,800,000).
How can I get the full precision of the number in SSRS?
Here is my query:
<?xml version="1.0" encoding="utf-8" ?>
<root>
<list title="Report Settings" relativeSiteUrl="/admin/finance/" folder="/" tableName="Folders">
<fields>Title, FOB_x0020_Beginning_x0020_Balanc, FOB_x0020_Equity_x0020_Balance, COB_x0020_Beginning_x0020_Balanc</fields>
<query>
</query>
</list>
</root>