Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Report Control
  New Posts New Posts RSS Feed - BUG with SUMSUB and moving columns
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

BUG with SUMSUB and moving columns

 Post Reply Post Reply
skiman View Drop Down

Joined: 20 December 2008
Location: Belgium
Status: Offline
Points: 88
Post Options Post Options   Thanks (0) Thanks(0)   Quote skiman Quote  Post ReplyReply Direct Link To This Post Topic: BUG with SUMSUB and moving columns
    Posted: 04 September 2015 at 5:46am

Using SUMSUB gives a lot of problems when moving columns. I have the following.

There is a grouptotal on the column Bedrag (amount). This is correct.

Now I move the column Bedrag to the second Column.

As you can see, the subtotal now totals the originally second column, which is the Date column. The subtotal is the sum of the days.

The cause of this problem is the way subsum is defined. It would be better to have a formula property for a column. Also the subsum should use the ITEMINDEX to define which items must be totalled.

I can dynamically change the groupformula, but with the current system i can't define in which column I want to put a subtotal, and I can't define that the subtotal in column 2 is in fact the data from item 4.

Anyone who uses this component and found a solution for this? I'm afraid there isn't any with the current behaviour and implamentation of the groupformula.

See also my previous post about the use of formula: Topic: row:groupformula <-> column:groupformula.
ABO Service
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.031 seconds.