1. 

   jasmondluk, Member

   
   
   select 'DBR.text' as 'DBR.text', 'Eye Level Interactive Education Centre (Discovery Park),Gift Icon Education Centre (Papillons Square)' as 'group_concat( centername )';
   
   select 'dbr.text', 'From: 2022-01-01 to 2022-01-31';
   
   select 'dbr.crosstab', 'Month';
   
   select 'dbr.sum', '[Income]';
   
   select 'dbr.hsum', '[Income]';
   
   select 'dbr.summary.text', 'Course', 'Total';
   
   select 'dbr.search', 1;
   
   select 'dbr.subtitle', 'Monthly Revenue By Subject';
   
   select 'dbr.sort', 'Course';
   
   select 'dbr.export.options', 'autosize', 1;
   
   select 'Eye Level Interactive Education Centre (Discovery Park)' as 'Center', '(Sun) English' as 'Course', '7 Eng' as 'Code', '2022-01' as 'Month', 5643.0 as '[Income]'
   
   union all
   
   select 'Eye Level Interactive Education Centre (Discovery Park)', '(Sun) Mathematics', '7 Math', '2022-01', 12011.0
   
   union all
   
   select 'Eye Level Interactive Education Centre (Discovery Park)', '(Sun) Sparks', '7 SPK', '2022-01', 2403.0
   
   union all
   
   select 'Eye Level Interactive Education Centre (Discovery Park)', 'Active Writers', 'R AW', '2022-01', 6995.0
   
   union all
   
   select 'Eye Level Interactive Education Centre (Discovery Park)', 'English', 'R Eng', '2022-01', 35850.0
   
   union all
   
   select 'Eye Level Interactive Education Centre (Discovery Park)', 'Grammar', 'R Gmar', '2022-01', 1250.0
   
   union all
   
   select 'Eye Level Interactive Education Centre (Discovery Park)', 'Mathematics', 'R Math', '2022-01', 73459.5
   
   union all
   
   select 'Eye Level Interactive Education Centre (Discovery Park)', 'Sparks', 'R SPK', '2022-01', 23400.0
   
   union all
   
   select 'Gift Icon Education Centre (Papillons Square)', 'Abacus', 'Abacus', '2022-01', 1096.666667
   
   union all
   
   select 'Gift Icon Education Centre (Papillons Square)', 'Cambridge English', 'CE', '2022-01', 2716.666667
   
   union all
   
   select 'Gift Icon Education Centre (Papillons Square)', 'Drama Course (Sat)', 'DramaSat', '2022-01', 1400.0
   
   union all
   
   select 'Gift Icon Education Centre (Papillons Square)', 'Eliteracy', 'ELITE', '2022-01', 300.0
   
   union all
   
   select 'Gift Icon Education Centre (Papillons Square)', 'Eliteracy (30 mins)', 'ELITE 30', '2022-01', 127.5
   
   union all
   
   select 'Gift Icon Education Centre (Papillons Square)', 'EnglishX', 'ENGX', '2022-01', 765.0
   
   union all
   
   select 'Gift Icon Education Centre (Papillons Square)', 'Homework Class', 'HC', '2022-01', 3714.0
   
   union all
   
   select 'Gift Icon Education Centre (Papillons Square)', 'Iconic Math', 'MATH', '2022-01', 450.0
   
   union all
   
   select 'Gift Icon Education Centre (Papillons Square)', 'SEN Training (Miss Ho)', 'Miss Ho', '2022-01', 1012.666667
   
   union all
   
   select 'Gift Icon Education Centre (Papillons Square)', 'Oil painting', 'OilP', '2022-01', 0.0
   
   union all
   
   select 'Gift Icon Education Centre (Papillons Square)', 'Oral 447', 'ORAL', '2022-01', 1740.0
   
   union all
   
   select 'Gift Icon Education Centre (Papillons Square)', 'SEN Training', 'SEN T', '2022-01', 1125.0
   
   union all
   
   select 'Gift Icon Education Centre (Papillons Square)', 'SEN 功輔 3小時', 'SEN 功輔', '2022-01', 2742.0
   
   union all
   
   select 'Gift Icon Education Centre (Papillons Square)', 'SEN功輔 1.5 小時', 'SEN功輔', '2022-01', 2042.0
   
   union all
   
   select 'Gift Icon Education Centre (Papillons Square)', 'Sketching', 'sketch', '2022-01', 0.0
   
   union all
   
   select 'Gift Icon Education Centre (Papillons Square)', 'SuPhonics', 'SPHON', '2022-01', 300.0
   
   union all
   
   select 'Gift Icon Education Centre (Papillons Square)', 'Writing Warriors', 'WRTW', '2022-01', 2856.0;
   
   select 'dbr.chart', 'Pie3D', 'Revenue by Course', 800, 500;
   
   select 'dbr.colstyle', 1, 't';
   
   select 'dbr.colstyle', 2, '{label}
   
       {percent}%';
   
   select 'Sparks' as 'Course', 23400.0 as '[Income]'
   
   union all
   
   select 'Mathematics', 73459.5
   
   union all
   
   select 'English', 35850.0
   
   union all
   
   select '(Sun) Mathematics', 12011.0
   
   union all
   
   select '(Sun) English', 5643.0
   
   union all
   
   select '(Sun) Sparks', 2403.0
   
   union all
   
   select 'Active Writers', 6995.0
   
   union all
   
   select 'Grammar', 1250.0
   
   union all
   
   select 'Writing Warriors', 2856.0
   
   union all
   
   select 'Iconic Math', 450.0
   
   union all
   
   select 'SEN Training', 1125.0
   
   union all
   
   select 'Sketching', 0.0
   
   union all
   
   select 'EnglishX', 765.0
   
   union all
   
   select 'SEN Training (Miss Ho)', 1012.666667
   
   union all
   
   select 'Oil painting', 0.0
   
   union all
   
   select 'SEN 功輔 3小時', 2742.0
   
   union all
   
   select 'Homework Class', 3714.0
   
   union all
   
   select 'Cambridge English', 2716.666667
   
   union all
   
   select 'Eliteracy (30 mins)', 127.5
   
   union all
   
   select 'Oral 447', 1740.0
   
   union all
   
   select 'SEN功輔 1.5 小時', 2042.0
   
   union all
   
   select 'SuPhonics', 300.0
   
   union all
   
   select 'Abacus', 1096.666667
   
   union all
   
   select 'Eliteracy', 300.0
   
   union all
   
   select 'Drama Course (Sat)', 1400.0;
   
   
2. 

   myDBR Team, Key Master

   Can you elaborate what do you mean by "first column is not sorted as shown"? Does it not sort at all or is the sorting order wrong?

   Are you referring to the first crosstable resultset?

   The first column should sort as expected.
   --
   myDBR Team
3. 

   jasmondluk, Member

   Yes it is not sorted. You can see the image in https://dreamware.click/mydbr1.png
4. 

   myDBR Team, Key Master

   Hi,
   you have set the sorting to be based on the Course-column:

   select 'dbr.sort', 'Course';

   The Course-column is sorted alphabetically (parentheses are sorted before letters).

   --
   myDBR Team
5. 

   jasmondluk, Member

   got it. Thanks.

Reply

You must log in to post.