Questions on Crosstab report sorting

(7 posts) (2 voices)

Tags:

No tags yet.

  1. chadwickhung, Member

    Dear Sir,
    I've a problem in sorting crosstab report, We need both the left side column and the top crosstab column to be sorted.

    e.g. the crosstab column is Y for below.
    select X, Y, Z from tableA;

    if I do select X, Y, Z from tableA order by X,Y then Y the crosstab column may not be shown as sorted on report

    if I do select X, Y, Z from tableA order by Y then X may not be shown as sorted.

    Please advise.

    Thanks and regards,
    Chadwick

  2. myDBR Team, Key Master

    Chadwick,
    by default, myDBR orders the cross tab columns based on the data. If you want to pre-define the cross tab column order or show columns that do not exists in the data, you can use the dbr.crosstab.col-command.

    See examples in documentation.

    --
    myDBR Team

  3. chadwickhung, Member

    Thanks. Can we have newline in the header?
    Best regards,
    Chadwick

  4. myDBR Team, Key Master

    Yes,
    'dbr.html:' works also in headers:

    select name as 'dbr.html:Client
    name'
    from clients;

    --
    myDBR Team

  5. myDBR Team, Key Master

    Yes,
    'dbr.html:' works also in headers:

    select name as 'dbr.html:Client< br>name'
    from clients;

    --
    myDBR Team

  6. chadwickhung, Member

    Sorry, what I mean header is the cross-tab column. If the value of the cross-tab column contains newline, I want it to break into the 2nd line but seems like I can't apply style to a cross-tab column, so I don't know how to show the line break.

    Please kindly advise.
    Best regards,
    Chadwick

  7. myDBR Team, Key Master

    You can use CSS to allow showing the whitespaces :

    select 'dbr.css', '.cell_ct {white-space: pre}';

    --
    myDBR Team


Reply

You must log in to post.