Sorting Crosstab Header

(5 posts) (3 voices)
  • Started 1 year ago by nsepetys
  • Latest reply from myDBR Team
  1. nsepetys, Member

    Hello myDBR Representative,

    How's it going? Is it possible to sort the crosstab header (shown by using the dbr.crosstab.header command) like by using a command similar to dbr.crosstab.col? If there's no direct way to do this do you guys have any work around ideas?

    Thanks,
    Noah

    Posted 1 year ago #
  2. myDBR Team, Key Master

    Noah,
    There is (an undocumented) command dbr.crosstab.header.col which works like dbr.crosstab.col.

    --
    myDBR Team

    Posted 1 year ago #
  3. nsepetys, Member

    Beautiful! I should have just taken a stab at the command to see if it was undocumented. Can we document that so others can benefit from it? Thanks for your help!

    Posted 1 year ago #
  4. john, Member

    on my report this isn't sorting.
    When i run with &export=sql i can see the order of the dbr.crosstab.header.col which is correct but the crosstab is in a different order

    selection from when run with &export=sql

    Begining of Report
    select 'dbr.parameters.show'; select 'dbr.subtitle', 'Income/expense.'; select 'dbr.crosstab', 'yeardate'; select 'dbr.sum', 'Amount'; select 'dbr.hsum', 'Amount'; select 'dbr.hidecolumn', 'Accounttype'; select 'dbr.summary.options', 'skip_single_line_summary'; select 'dbr.keepwithnext'; ;

    select 'dbr.crosstab.header.col', '2024 2' union all select 'dbr.crosstab.header.col', '2019 9' union all select 'dbr.crosstab.header.col', '2019 8'

    begining of crosstab
    select 'Automotive Fuel 8110' as 'Account', '2015 9' as 'yeardate', 5 as 'Accounttype', 20.0 as '[Amount]' union all select 'Automotive Fuel 8110', '2015 8', 5, 67.82 union all select 'Automotive Fuel 8110', '2015 7', 5, 9.75 union all select 'Automotive Fuel 8110', '2015 6', 5, 20.0 union all

    Posted 1 year ago #
  5. myDBR Team, Key Master

    John,
    to set the order for crosstab columns, use the 'dbr.crosstab.col' commmand. See documentation.

    The dbr.crosstab.header.col-command is used to define the order of the 2nd level headers defined by the dbr.crosstab.header.

    --
    myDBR Team

    Posted 1 year ago #

Reply

You must log in to post.