Wrong aggregate SUM when filter in web page

(5 posts) (2 voices)


No tags yet.

  1. spyhunter88, Member

    Hi MyDBR Team,

    I get issue with new this feature. Look at Amt column, I think the problem is formatted number, javascript looks for number that's formatted, not its value. I use comma for thousand and point for decimal.

    I think the best solution is put raw value inside a html tag inside this cell.


  2. myDBR Team, Key Master

    Please open a ticket in the support and include the SQL-export of the report. We'll take a look at it.

    Number separators (decimal point, thousand separator) is done via preferences, you should not force them in reports as they are part of user's locale settings. The point it that same reports will work among different users even if users have different decimal points / thousand separators.

    myDBR Team

  3. spyhunter88, Member

    Of course we use style to define how value is display, not in sql.

    select 'dbr.column.filter', 'Customer', 'text'; select 'dbr.sum', 'Val';

    select 'A' as Customer, 1230000000 as Val union select 'B', 123123333 union select 'AC', 5000;

    And I am in version 4.6.4 (3039).


  4. myDBR Team, Key Master

    The issue is now fixed, just run the updater. Thanks for reporting this.

    myDBR Team

  5. spyhunter88, Member

    Many thanks for that, I will update soon when possible.


You must log in to post.