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.