report render bug?
Posted: Wed Jun 15, 2011 10:25 am
I am having some issues with a report rendering semi-randomly. I can't figure it out. Here are two screenshots:
(one row)
(multiple rows)
In the first example, the query returns a single record, and you can see that everything seems to come out right. But, when I have multiple rows returned (the second screenshot), you can see that the order details for order#10747001, don't match the data returned in the first screenshot...convenience fee is rounded, but, the Total column remains accurate. Additionally, with order 114880711, you can see a disparity between the total, and the other fields (convfee was 2.95 again, and the subtotal was $0.75).
I have doublechecked the data being entered into my datatable, and it does not change for a given row, regardless of what other rows may be returned with it.
I conclude, then, that the Reports.Fx component is somehow responsible for this rounding (more like a floor() function, than a round() ).
Finally, here's a sample of the data that is being sent in the 'multi-row' scenario(in which you can see the proper values as they were inserted into the DataTable object)...
(one row)
(multiple rows)
In the first example, the query returns a single record, and you can see that everything seems to come out right. But, when I have multiple rows returned (the second screenshot), you can see that the order details for order#10747001, don't match the data returned in the first screenshot...convenience fee is rounded, but, the Total column remains accurate. Additionally, with order 114880711, you can see a disparity between the total, and the other fields (convfee was 2.95 again, and the subtotal was $0.75).
I have doublechecked the data being entered into my datatable, and it does not change for a given row, regardless of what other rows may be returned with it.
I conclude, then, that the Reports.Fx component is somehow responsible for this rounding (more like a floor() function, than a round() ).
Finally, here's a sample of the data that is being sent in the 'multi-row' scenario(in which you can see the proper values as they were inserted into the DataTable object)...
Code: Select all
CCFailed false
Cost 0.95
DepositAccount No Deposit Account Specified
convert date value to string -> 2011-04-06 00:00:00
FullCode 4250-40-12
ItemConvFee 0
ItemHandling 0
ItemHandlingConvFee 0
ItemID 45
ItemName Skyward Mug
ItemShipping 0
ItemSubTotal 0.95
ItemTax 0.07
ItemTotal 1.02
OrderConvFee 0
convert date value to string -> 2011-04-06 15:33:31
OrderHandling 0
OrderID 114880033
OrderItemID 169
OrderShipping 0
OrderTax 0.07
OrderTotal 1.02
OrdersCustID 114880
Pay_CCNum xxxxxxxxxxxx3734
Pay_Name David C Thorson
Pay_Type VS
Quantity 1
SKU SkywardMug
SOrderTimeOnly 03:33PM
ShortCode 4250-40-12
SubTotal 0.95
========================================
CCFailed false
Cost 50
DepositAccount No Deposit Account Specified
convert date value to string -> 2011-01-03 00:00:00
FullCode No Account Code Specified
ItemConvFee 2.95
ItemHandling 0
ItemHandlingConvFee 2.95
ItemID 16
ItemName Bon Appetit Food Service $50
ItemShipping 0
ItemSubTotal 50
ItemTax 0
ItemTotal 52.95
OrderConvFee 2.95
convert date value to string -> 2011-01-03 15:52:40
OrderHandling 0
OrderID 10747001
OrderItemID 871
OrderShipping 0
OrderTax 0
OrderTotal 52.95
OrdersCustID 10747
Pay_CCNum xxxxxxxxxxxx1111
Pay_Name 11111
Pay_Type Visa
Quantity 1
SKU BONA-50
SOrderTimeOnly 03:52PM
ShortCode None
SubTotal 50
========================================
CCFailed false
Cost 0.75
DepositAccount No Deposit Account Specified
convert date value to string -> 2011-02-02 00:00:00
FullCode 4250-40-12
ItemConvFee 2.95
ItemHandling 0
ItemHandlingConvFee 2.95
ItemID 77
ItemName Apple
ItemShipping 0
ItemSubTotal 0.75
ItemTax 0
ItemTotal 3.7
OrderConvFee 2.95
convert date value to string -> 2011-02-02 13:37:06
OrderHandling 0
OrderID 114880711
OrderItemID 877
OrderShipping 0
OrderTax 0
OrderTotal 3.7
OrdersCustID 114880
Pay_CCNum xxxxxxxxxxxx1111
Pay_Name 111111
Pay_Type Visa
Quantity 1
SKU 002-Apple
SOrderTimeOnly 01:37PM
ShortCode 4250-40-12
SubTotal 0.75