report render bug?

[brianj774]

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)...

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

[Ivan]

Hello,

Can you please send us a sample report template with data or a simple test project, which reproduce the issue?

Thank you.

[brianj774]

I'll try

[Andrew]

Ok! Let us know about the result.

[brianj774]

ok, here we are....

[Vladimir]

Hello,

Please replace the column type in your project:

Code: Select all

c = new DataColumn("OrderConvFee", StorageType.IntType);

to:

Code: Select all

c = new DataColumn("OrderConvFee", StorageType.DecimalType);

Thank you.

[brianj774]

oh, interesting....

It appears that the switch block I use in a for loop to generate these dataColumns chooses different items depending on my data rows...sometimes I'll get a decimal type, and sometimes I'll get an integer type.

Tracking it down now...thanks for the hint!

[Alex K.]

Ok.
Let us know if you need any additional help.