dbr.crosstab.order bug?

(4 posts) (2 voices)

Tags:

No tags yet.

  1. ziuras, Member

    Please run this report:
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    if object_id('sp_DBR_crosstab_order','P') is not null
    drop procedure sp_DBR_crosstab_order
    go
    create procedure sp_DBR_crosstab_order
    as
    begin

    select 'dbr.crosstab', 'Group';
    select 'dbr.crosstab.order' , 'asc'
    select 'dbr.hsum', 'Suma';
    select 'dbr.sum', 'Suma';

    select 'Name1' as name, 'A' as 'Group', 10 as Suma
    union
    select 'Name9' as name, 'O' as 'Group', 10 as Suma
    union
    select 'Name8' as name, 'Z' as 'Group', 10 as Suma
    union
    select 'Name2' as name, 'A' as 'Group', 10 as Suma
    union
    select 'Name2' as name, 'O' as 'Group', 10 as Suma
    union
    select 'Name2' as name, 'Z' as 'Group', 10 as Suma

    end
    go
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Crosstab columns are ordered:
    A, O, Total, Z

    Posted 4 months ago #
  2. ziuras, Member

    and dbr.sum wrong counted
    ant Column Z (named as Total - third crosstab column) does not have any value.

    myDBR 5.4.0 (build 3854)

    Posted 4 months ago #
  3. myDBR Team, Key Master

    Yes,
    the summary column was included in the column sorting, which was not correct. Fixed now in new build.

    Thank you for pointing this out.

    --
    myDBR Team

    Posted 4 months ago #
  4. ziuras, Member

    thanks

    Posted 4 months ago #

Reply

You must log in to post.