Invalid report totals (sum aggregation) in interactive report

[Johan1959]

When an interactive report with totals (sum aggregation) has hidden columns that also include a total then the totals that appear in the excel file are incorrect. It seems the total from a hidden column is added to the excel.

A bypass is to remove the total (sum calculation) from the hidden column.

DemoBAQuote1 (10).xlsx

[glebovpavel]

Could you try the last version: 3.21. Probably is related to #70

[jporrata1]

Hi Pavel

Where can I download it?

Which files do I need to import to the application? All files or just one?

Thanks a lot for your help!

Javier

On Wed, Jan 22, 2020 at 5:12 PM Pavel Glebov notifications@github.com wrote:

Could you try the last version: 3.21. Probably is related to #70 https://github.com/glebovpavel/IR_to_MSExcel/issues/70

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/glebovpavel/IR_to_MSExcel/issues/69?email_source=notifications&email_token=AKQSIT2BSDIFW7K4YD4GTIDQ7CZETA5CNFSM4JSQHJG2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEJVD3BY#issuecomment-577387911, or unsubscribe https://github.com/notifications/unsubscribe-auth/AKQSIT644EL3L7DCFKHAJF3Q7CZETANCNFSM4JSQHJGQ .

[mrpele]

Hi Pavel, After fixed issue #70, sum aggregations are incorrect.. Before that, if was ok for me. Tested on Apex 19.2 Thanks. Miraç

[glebovpavel]

Fixed in 3.21

[mrpele]

3.22 didnt fix this issue for me. Here are the screenshots;

[glebovpavel]

@mrpele Could you reproduce this bug on https://apex.oracle.com/pls/apex/f?p=35446:1 ? I was trying but 3.22 works correct for me.

[mrpele]

I think i found the bug. It is caused by the hidden item/s when that hidden item is used in a link or something like that. In my application, i have 'hidden column' item named as 'CARD_ITEM_ID' and i am using it in a visible link column named as 'DELETEROW' (URL: javascript:$.event.trigger('deleteRow', #CARD_ITEM_ID#);). If i set 'CARD_ITEM_ID' plain text and visible in ir then the aggregation is true. Or if i delete the link it is true too. Otherwise it is wrong. If i set 'CARD_ITEM_ID' as plain text but hidden in ir then it doesnt work too. It must be visible as a column. If ir doesnt have any hidden item then it works like charm. :D

I am looking forward for a solution.. Thanks.

[glebovpavel]

@mrpele Thank you for detailed description!!! I think now this bug should be fixed in 3.24

[mrpele]

It seems ok.. Thanks Pavel. Tested on Apex 19.2