Some of the fields become blank after exporting to excel

myDBR Forums » General discussion

Some of the fields become blank after exporting to excel

(4 posts) (2 voices)

Started by jasmondluk
Latest reply from jasmondluk

Tags:

No tags yet.

jasmondluk, Member

After exporting to excel, some of the fields become blank however it is ok when download PDF. For example first name in rows 67-121

select 'DBR.text' as 'DBR.text', '優優教育中心(港島）' as 'centername';

select 'dbr.sum', 'Outstanding amount';
select 'dbr.summary.text', 'Tuition total', 'Total';

select 'dbr.search', 1;

select 'dbr.hdr', 1;

select 'dbr.subtitle', 'Oustanding tuition fee';

select 'dbr.column.filter', 'Outstanding amount', 'text';
select 'dbr.column.filter', 'First name', 'text';
select 'dbr.column.filter', 'Last name', 'text';
select 'dbr.column.filter', 'ID', 'text';
select 'dbr.column.filter', 'No. of class', 'text';
select 'dbr.column.filter', 'Subject name', 'text';
select 'dbr.column.filter', 'Tuition total', 'text';

select '2022-04' as 'Month (1st class)', 20 as 'Overdue (days)', '565453' as 'Enollment ID', '皓弘' as 'First name', '劉' as 'Last name', 'UUC0277' as 'ID', 'O11-C-1' as 'Subject', 'Online 一對一 (半小時) - 堂數' as 'Subject name', '2022-04-01' as 'Date enrolled/renewed', '1' as 'No. of class', '2022-04-01' as 'Adjusted first class', '2022-04-01' as 'Adjusted last class', '300' as 'Tuition total', 300.0 as 'Outstanding amount'
union all
select '2022-04', 20, '560712', '梓晴', '王', 'UUC0441', 'OP-C-1', 'Online 小學小組課 (半小時) - 堂數', '2022-03-19', '10', '2022-04-01', '2022-06-10', '1500', 1500.0
union all
select '2022-04', 20, '560714', '淳昕', '李', 'UUC0583', 'OP-C-1', 'Online 小學小組課 (半小時) - 堂數', '2022-03-19', '7', '2022-04-01', 'TBD', '1050', 0.0
union all
select '2022-04', 20, '563787', '俊銘', '盧', 'UUC1220', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-03-28', '10', '2022-04-01', '2022-05-10', '1500', 0.0
union all
select '2022-04', 20, '565429', '熙涵', '黎', 'UUC1628', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-01', '6', '2022-04-01', '2022-04-13', '900', -600.0
union all
select '2022-04', 20, '565432', '啟洺 Spencer', '孫', 'UUC1696', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-01', '10', '2022-04-01', '2022-05-11', '1500', 0.0
union all
select '2022-04', 19, '560767', '致永', '王', 'UUC0133', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-19', '10', '2022-04-02', '2022-06-04', '3000', 0.0
union all
select '2022-04', 19, '564760', '翼衡', '郭', 'UUC0241', 'O11-C-1', 'Online 一對一 (半小時) - 堂數', '2022-03-30', '2', '2022-04-02', '2022-04-09', '600', 0.0
union all
select '2022-04', 19, '560738', '信諺', '陳', 'UUC0344', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-19', '10', '2022-04-02', '2022-06-11', '3000', 0.0
union all
select '2022-04', 19, '565670', '朗豐', '楊', 'UUC0414', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-04-02', '5', '2022-04-02', '2022-04-30', '1500', 1500.0
union all
select '2022-04', 19, '560719', '彥熹', '黃', 'UUC0578', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-19', '8', '2022-04-02', '2022-05-28', '2400', 0.0
union all
select '2022-04', 19, '560734', '家妍', '黃', 'UUC0803', 'OKIB-C-1', 'Online 幼兒中文IB課 (一小時) - 堂數', '2022-03-19', '10', '2022-04-02', '2022-06-11', '3000', 3000.0
union all
select '2022-04', 19, '558064', '英傑', '何', 'UUC0901', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-11', '10', '2022-04-02', '2022-06-11', '3000', 0.0
union all
select '2022-04', 19, '560731', '晞雅', '黃', 'UUC0932', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-19', '10', '2022-04-02', '2022-06-11', '3000', 3000.0
union all
select '2022-04', 19, '565671', '恩妍', '楊', 'UUC1022', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-04-02', '5', '2022-04-02', '2022-04-30', '1500', 1500.0
union all
select '2022-04', 19, '565676', '彥臻', '馮', 'UUC1233', 'O11-C-1', 'Online 一對一 (半小時) - 堂數', '2022-04-02', '3', '2022-04-02', '2022-04-09', '900', 0.0
union all
select '2022-04', 19, '560819', '澤軒', '林', 'UUC1244', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-03-19', '10', '2022-04-02', '2022-04-30', '1500', 0.0
union all
select '2022-04', 19, '560769', '卓瑜', '林', 'UUC1366', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-19', '10', '2022-04-02', '2022-06-11', '3000', 0.0
union all
select '2022-04', 19, '560816', '希瑜', '林', 'UUC1368', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-19', '10', '2022-04-02', '2022-06-11', '3000', 0.0
union all
select '2022-04', 19, '560814', '駿鴻', '馬', 'UUC1417', 'O11-C-1', 'Online 一對一 (半小時) - 堂數', '2022-03-19', '10', '2022-04-02', 'TBD', '3000', 3000.0
union all
select '2022-04', 18, '565741', '熙妍', '梁', 'UUC0227', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-03', '10', '2022-04-03', '2022-04-28', '1500', 1500.0
union all
select '2022-04', 18, '548529', '浩智', '戴', 'UUC0653', 'O11-C-3', 'Online 一對一 (一小時) - 堂數', '2022-02-16', '10', '2022-04-03', '2022-06-12', '6000', 0.0
union all
select '2022-04', 18, '567234', '晉曦', '梁', 'UUC0655', 'O11-C-1', 'Online 一對一 (半小時) - 堂數', '2022-04-07', '4', '2022-04-03', '2022-04-24', '1200', 0.0
union all
select '2022-04', 18, '561251', '芷悠', '許', 'UUC0863', 'O11-C-3', 'Online 一對一 (一小時) - 堂數', '2022-03-20', '2', '2022-04-03', '2022-04-10', '1200', 1200.0
union all
select '2022-04', 18, '561248', '善童', '湯', 'UUC1085', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-03-20', '10', '2022-04-03', '2022-06-12', '1500', 1100.0
union all
select '2022-04', 18, '563939', '善志', '梁', 'UUC1739', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-29', '1', '2022-04-03', '2022-04-03', '300', 0.0
union all
select '2022-04', 17, '563881', '熙雋', '梁', 'UUC0226', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-03-29', '10', '2022-04-04', '2022-04-28', '1500', 1500.0
union all
select '2022-04', 17, '561464', '欣彤', '謝', 'UUC0758', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-21', '10', '2022-04-04', '2022-06-06', '3000', 0.0
union all
select '2022-04', 17, '563725', '芷喬', '王', 'UUC0838', 'OM-1', 'Online 中學課（一小時）-堂數', '2022-03-28', '5', '2022-04-04', '2022-05-23', '1500', 0.0
union all
select '2022-04', 17, '565910', '晞媛', '李', 'UUC0869', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-04', '10', '2022-04-04', '2022-06-10', '1500', 1500.0
union all
select '2022-04', 17, '561463', '梓華', '黃', 'UUC0940', 'OKIB-C-1', 'Online 幼兒中文IB課 (一小時) - 堂數', '2022-03-21', '10', '2022-04-04', 'TBD', '3000', 3000.0
union all
select '2022-04', 17, '565933', '濬賢', '李', 'UUC1094', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-04', '10', '2022-04-04', '2022-06-06', '1500', 1500.0
union all
select '2022-04', 17, '563880', '暐皓', '蘇', 'UUC1139', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-03-29', '10', '2022-04-04', '2022-06-27', '1500', 1500.0
union all
select '2022-04', 17, '565780', '揮明', '梁', 'UUC1319', '011-C-5', 'online一對一（十五分鍾）-堂數', '2022-04-04', '3', '2022-04-04', '2022-04-08', '450', 450.0
union all
select '2022-04', 17, '565912', '栢謙', '嚴', 'UUC1545', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-04', '10', '2022-04-04', '2022-06-06', '1500', 1500.0
union all
select '2022-04', 15, '563467', '子儁', '蔡', 'UUC0028', 'OKIB-C-1', 'Online 幼兒中文IB課 (一小時) - 堂數', '2022-03-26', '2', '2022-04-06', '2022-04-13', '600', -2400.0
union all
select '2022-04', 15, '563468', '澤謙', '蔡', 'UUC0029', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-26', '10', '2022-04-06', '2022-05-13', '3000', 0.0
union all
select '2022-04', 15, '564696', '穎妍', '李', 'UUC0054', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-03-30', '2', '2022-04-06', '2022-04-13', '300', 0.0
union all
select '2022-04', 15, '564698', '卓峰', '李', 'UUC0056', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-30', '2', '2022-04-06', '2022-04-13', '600', 0.0
union all
select '2022-04', 15, '567190', '梓軒', '徐', 'UUC0214', 'OKIB-C-1', 'Online 幼兒中文IB課 (一小時) - 堂數', '2022-04-07', '1', '2022-04-06', '2022-04-06', '300', 0.0
union all
select '2022-04', 15, '561380', '嘉信', '陳', 'UUC0274', 'OP-C-1', 'Online 小學小組課 (半小時) - 堂數', '2022-03-21', '6', '2022-04-06', '2022-04-27', '900', 900.0
union all
select '2022-04', 15, '563204', '維廷', '高', 'UUC0286', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-25', '3', '2022-04-06', '2022-04-20', '900', 900.0
union all
select '2022-04', 15, '563202', '維承', '高', 'UUC0287', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-25', '2', '2022-04-06', '2022-04-13', '600', 600.0
union all
select '2022-04', 15, '567018', '忠傑', '陳', 'UUC0663', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-06', '7', '2022-04-06', '2022-04-14', '1050', 1050.0
union all
select '2022-04', 15, '564708', '梓銘', '馬', 'UUC0709', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-30', '2', '2022-04-06', '2022-04-13', '600', 0.0
union all
select '2022-04', 15, '563197', '卓知', '司徒', 'UUC0886', 'OPIB-C-2', 'Online 小學中文IB課 (一個半小時) - 堂數', '2022-03-25', '2', '2022-04-06', '2022-04-13', '900', 900.0
union all
select '2022-04', 15, '564699', '卓翹', '李', 'UUC0888', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-30', '2', '2022-04-06', '2022-04-13', '600', 0.0
union all
select '2022-04', 15, '563274', '曉彤', '李', 'UUC0902', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-25', '10', '2022-04-06', '2022-04-14', '3000', 0.0
union all
select '2022-04', 15, '565464', '俊希', '區', 'UUC0994', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-04-01', '6', '2022-04-06', '2022-04-22', '1800', 1800.0
union all
select '2022-04', 15, '562848', '彥男', '鄧', 'UUC1076', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-03-24', '2', '2022-04-06', '2022-04-13', '300', -1200.0
union all
select '2022-04', 15, '564702', '希行', '鍾', 'UUC1184', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-30', '2', '2022-04-06', '2022-04-13', '600', 600.0
union all
select '2022-04', 15, '563205', '爾甯', '林', 'UUC1218', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-25', '4', '2022-04-06', '2022-04-27', '1200', 1200.0
union all
select '2022-04', 15, '563199', '睿琪', '伍', 'UUC1260', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-25', '3', '2022-04-06', 'TBD', '900', 900.0
union all
select '2022-04', 15, '565431', '浩權', '蕭', 'UUC1486', 'OP-C-1', 'Online 小學小組課 (半小時) - 堂數', '2022-04-01', '2', '2022-04-06', '2022-04-08', '300', -1200.0
union all
select '2022-04', 15, '567025', '碩軒', '劉', 'UUC1492', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-06', '2', '2022-04-06', '2022-04-08', '300', 300.0
union all
select '2022-04', 15, '565462', '浚浲', '鄧', 'UUC1712', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-04-01', '10', '2022-04-06', '2022-05-04', '3000', 3000.0
union all
select '2022-04', 15, '567057', '善志', '梁', 'UUC1739', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-04-06', '4', '2022-04-06', '2022-04-13', '1200', 0.0
union all
select '2022-04', 15, '565890', '興道', '馬', 'UUC1741', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-04', '1', '2022-04-06', '2022-04-06', '150', 0.0
union all
select '2022-04', 14, '567244', '晞懿 Bria', '廖', 'UUC1721', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-07', '20', '2022-04-07', '2022-05-02', '3000', 3000.0
union all
select '2022-04', 14, '565887', '翼衡', '郭', 'UUC0241', 'OKIB-C-1', 'Online 幼兒中文IB課 (一小時) - 堂數', '2022-04-04', '2', '2022-04-07', '2022-04-08', '600', 600.0
union all
select '2022-04', 14, '561460', '珀昊', '馬', 'UUC0634', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-21', '10', '2022-04-07', '2022-06-20', '3000', 0.0
union all
select '2022-04', 14, '564854', '晉曦', '梁', 'UUC0655', 'O11-C-1', 'Online 一對一 (半小時) - 堂數', '2022-03-31', '2', '2022-04-07', '2022-04-14', '600', 0.0
union all
select '2022-04', 14, '567248', '永晞', '譚', 'UUC0732', 'O11-C-1', 'Online 一對一 (半小時) - 堂數', '2022-04-07', '10', '2022-04-07', '2022-05-05', '3000', 0.0
union all
select '2022-04', 14, '567254', '小瀚 Archie', '高', 'UUC0747', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-07', '20', '2022-04-07', '2022-05-03', '0', 0.0
union all
select '2022-04', 14, '563272', '穎悠', '甘', 'UUC0967', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-03-25', '10', '2022-04-07', '2022-06-09', '1500', 1500.0
union all
select '2022-04', 14, '563270', '靜妍', '甘', 'UUC1176', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-25', '10', '2022-04-07', '2022-06-09', '3000', 3000.0
union all
select '2022-04', 14, '567273', '曉晴', '李', 'UUC1225', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-07', '3', '2022-04-07', '2022-04-11', '450', 450.0
union all
select '2022-04', 14, '567250', '智希', '梁', 'UUC1337', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-04-07', '2', '2022-04-07', '2022-04-14', '600', 600.0
union all
select '2022-04', 14, '567271', '穎琳', '關', 'UUC1390', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-07', '2', '2022-04-07', '2022-04-12', '300', 300.0
union all
select '2022-04', 14, '567247', '思慧', '李', 'UUC1478', 'OKIB-C-1', 'Online 幼兒中文IB課 (一小時) - 堂數', '2022-04-07', '10', '2022-04-07', '2022-06-27', '3000', 3000.0
union all
select '2022-04', 13, '563200', '靖桐', '林', 'UUC0442', 'OPIB-C-2', 'Online 小學中文IB課 (一個半小時) - 堂數', '2022-03-25', '10', '2022-04-08', '2022-06-08', '4500', 4500.0
union all
select '2022-04', 13, '560713', '晉霆', '李', 'UUC0450', 'OP-C-1', 'Online 小學小組課 (半小時) - 堂數', '2022-03-19', '10', '2022-04-08', '2022-06-10', '1500', 1500.0
union all
select '2022-04', 13, '552635', '亦姿', '魏', 'UUC0969', '011-C-4', 'Online 一對一 (一個半小時) - 堂數', '2022-02-23', '3', '2022-04-08', '2022-04-15', '2700', 2700.0
union all
select '2022-04', 13, '567375', '榕恩', '林', 'UUC1245', 'O11-C-3', 'Online 一對一 (一小時) - 堂數', '2022-04-08', '10', '2022-04-08', 'TBD', '6000', 6000.0
union all
select '2022-04', 13, '563262', '毅軒', '陳', 'UUC1331', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-25', '10', '2022-04-08', '2022-06-17', '3000', 0.0
union all
select '2022-04', 13, '567377', '知幸', '黃', 'UUC1705', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-08', '10', '2022-04-08', '2022-05-12', '1500', 1500.0
union all
select '2022-04', 13, '565435', '基恩', '林', 'UUC1714', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-04-01', '3', '2022-04-08', '2022-04-20', '900', 0.0
union all
select '2022-04', 12, '565742', '晉嵐', '余', 'UUC0134', 'O11-C-1', 'Online 一對一 (半小時) - 堂數', '2022-04-03', '5', '2022-04-09', '2022-05-13', '1500', 1500.0
union all
select '2022-04', 12, '567434', '芯宜', '李', 'UUC0535', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-04-08', '10', '2022-04-16', 'TBD', '3000', 3000.0
union all
select '2022-04', 12, '560809', '元征', '王', 'UUC0542', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-19', '10', '2022-04-09', '2022-06-18', '3000', 0.0
union all
select '2022-04', 12, '567438', '晞妍', '方', 'UUC0948', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-08', '1', '2022-04-09', '2022-04-09', '150', 150.0
union all
select '2022-04', 12, '560813', '天立', '陳', 'UUC1361', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-19', '10', '2022-04-16', 'TBD', '3000', 3000.0
union all
select '2022-04', 12, '567436', '栢熙', '張', 'UUC1593', 'OKIB-C-1', 'Online 幼兒中文IB課 (一小時) - 堂數', '2022-04-08', '1', '2022-04-09', '2022-04-09', '300', 300.0
union all
select '2022-04', 11, '561252', '子言', '區', 'UUC0068', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-20', '10', '2022-04-10', 'TBD', '3000', 0.0
union all
select '2022-04', 11, '561253', '皓揚', '黃', 'UUC1278', 'O11-C-3', 'Online 一對一 (一小時) - 堂數', '2022-03-20', '10', '2022-04-10', '2022-06-12', '6000', 0.0
union all
select '2022-04', 11, '561254', '銳思', '黃', 'UUC1710', 'O11-C-3', 'Online 一對一 (一小時) - 堂數', '2022-03-20', '5', '2022-04-10', '2022-05-08', '3000', 0.0
union all
select '2022-04', 10, '561381', '嘉佑', '陳', 'UUC0264', 'OP-C-1', 'Online 小學小組課 (半小時) - 堂數', '2022-03-21', '2', '2022-04-11', '2022-04-25', '300', 300.0
union all
select '2022-04', 10, '560708', '愷敏', '馬', 'UUC0922', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-19', '4', '2022-04-11', '2022-04-14', '1200', 0.0
union all
select '2022-04', 10, '568034', '曉頤', '羅', 'UUC1128', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-11', '4', '2022-04-11', '2022-04-14', '600', 600.0
union all
select '2022-04', 10, '565777', '奕童', '黃', 'UUC1370', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-04-04', '10', '2022-04-11', '2022-07-04', '3000', 0.0
union all
select '2022-04', 10, '568028', '鳴希', '馬', 'UUC1676', 'O11-C-1', 'Online 一對一 (半小時) - 堂數', '2022-04-11', '1', '2022-04-11', '2022-04-11', '300', 300.0
union all
select '2022-04', 10, '568029', '俊熙', '鄧', 'UUC1723', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-11', '10', '2022-04-11', '2022-05-09', '1500', 1500.0
union all
select '2022-04', 10, '567251', '天裕', '黃', 'UUC1736', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-04-07', '5', '2022-04-11', '2022-05-16', '1500', 1500.0
union all
select '2022-04', 9, '567986', '浩一', '林', 'UUC0432', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-04-10', '4', '2022-04-12', '2022-04-19', '1200', 1200.0
union all
select '2022-04', 9, '568049', '延修', '陳', 'UUC0824', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-11', '1', '2022-04-12', '2022-04-12', '150', 150.0
union all
select '2022-04', 9, '561486', '樂恆', '唐', 'UUC0938', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-21', '1', '2022-04-12', '2022-04-12', '300', -2700.0
union all
select '2022-04', 9, '561485', '可忻', '林', 'UUC1051', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-21', '10', '2022-04-12', '2022-06-14', '3000', 0.0
union all
select '2022-04', 9, '568046', '彥諮', '馮', 'UUC1232', 'O12-C-3', 'Online 一對二 (一個半小時) - 堂數', '2022-04-11', '5', '2022-04-12', '2022-05-10', '3750', 0.0
union all
select '2022-04', 9, '568012', '子珵', '邵', 'UUC1291', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-11', '3', '2022-04-12', '2022-04-25', '450', 450.0
union all
select '2022-04', 9, '567193', '奕雯Abby ', '尤', 'UUC1335', 'OPIB-C-2', 'Online 小學中文IB課 (一個半小時) - 堂數', '2022-04-07', '1', '2022-04-12', '2022-04-12', '450', 450.0
union all
select '2022-04', 9, '568048', '志樂', '何', 'UUC1485', 'OKIB-C-1', 'Online 幼兒中文IB課 (一小時) - 堂數', '2022-04-11', '10', '2022-04-12', '2022-05-12', '3000', 3000.0
union all
select '2022-04', 9, '568039', '凱朗', '林', 'UUC1590', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-11', '10', '2022-04-12', '2022-06-14', '1500', 1500.0
union all
select '2022-04', 9, '568050', '謙樂', '王', 'UUC1703', 'OP-C-1', 'Online 小學小組課 (半小時) - 堂數', '2022-04-11', '1', '2022-04-12', '2022-04-12', '150', 150.0
union all
select '2022-04', 9, '561255', '銳思', '黃', 'UUC1710', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-20', '5', '2022-04-12', '2022-05-10', '1500', 0.0
union all
select '2022-04', 8, '564754', '偲桐', '盧', 'UUC0184', 'O12-C-2', 'Online 一對二 (一小時) - 堂數', '2022-03-30', '10', '2022-04-13', '2022-06-11', '5000', 5000.0
union all
select '2022-04', 8, '568532', '浩然', '陳', 'UUC0251', 'OPIB-C-2', 'Online 小學中文IB課 (一個半小時) - 堂數', '2022-04-13', '1', '2022-04-13', '2022-04-13', '450', 450.0
union all
select '2022-04', 8, '568551', '心妍 Elsa', '蘇', 'UUC0415', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-04-13', '10', '2022-04-13', '2022-06-22', '3000', 0.0
union all
select '2022-04', 8, '564707', '佩伶', '胡', 'UUC0521', 'O11-C-1', 'Online 一對一 (半小時) - 堂數', '2022-03-30', '10', '2022-04-13', '2022-06-15', '3000', 0.0
union all
select '2022-04', 8, '563198', '珞頤', '陳', 'UUC0995', 'OPIB-C-2', 'Online 小學中文IB課 (一個半小時) - 堂數', '2022-03-25', '1', '2022-04-13', '2022-04-13', '450', 450.0
union all
select '2022-04', 8, '568037', '謙柔', '董', 'UUC1293', 'O11-C-3', 'Online 一對一 (一小時) - 堂數', '2022-04-11', '10', '2022-04-13', '2022-07-04', '6000', 0.0
union all
select '2022-04', 8, '567931', '奕文', '潘', 'UUC1347', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-09', '10', '2022-04-13', '2022-05-17', '1500', 1500.0
union all
select '2022-04', 8, '560806', '凱鍒', '黃', 'UUC1547', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-03-19', '1', '2022-04-13', '2022-04-13', '150', -350.0
union all
select '2022-04', 7, '568941', '晟睿', '徐', 'UUC0382', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-14', '10', '2022-04-14', '2022-05-17', '1500', 1500.0
union all
select '2022-04', 7, '568175', '佩伶', '胡', 'UUC0521', 'OKIB-C-1', 'Online 幼兒中文IB課 (一小時) - 堂數', '2022-04-12', '1', '2022-04-14', '2022-04-14', '300', 300.0
union all
select '2022-04', 7, '563922', '松宏', '林', 'UUC0606', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-29', '5', '2022-04-14', '2022-04-22', '1500', 0.0
union all
select '2022-04', 7, '568940', '曉盈', '李', 'UUC0903', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-04-14', '10', '2022-04-14', '2022-05-18', '3000', 3000.0
union all
select '2022-04', 7, '568942', '其寬', '陳', 'UUC1101', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-14', '10', '2022-04-14', '2022-05-16', '1500', 1500.0
union all
select '2022-04', 7, '567924', '彥謙', '沈', 'UUC1716', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-04-09', '10', '2022-04-14', '2022-05-26', '3000', 3000.0
union all
select '2022-04', 5, '560812', '天悅', '陳', 'UUC1649', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-03-19', '10', '2022-04-16', '2022-06-18', '3000', 3000.0
union all
select '2022-04', 4, '569669', '芷悠', '許', 'UUC0863', '11-C-2', '中心一對一 (一小時) - 堂數', '2022-04-17', '10', '2022-04-17', '2022-06-19', '8000', 8000.0
union all
select '2022-04', 4, '569670', '澤軒', '林', 'UUC1244', 'O11-C-1', 'Online 一對一 (半小時) - 堂數', '2022-04-17', '1', '2022-04-17', '2022-04-17', '300', 300.0
union all
select '2022-04', 3, '565922', '晉光', '余', 'UUC0103', 'OP-C-1', 'Online 小學小組課 (半小時) - 堂數', '2022-04-04', '4', '2022-04-18', '2022-05-09', '600', 600.0
union all
select '2022-04', 2, '561787', '卓翹', '陳', 'UUC0031', 'ChIB-C-1', '中文IB課 (一個半小時) - 堂數', '2022-03-22', '10', '2022-04-19', '2022-06-21', '5400', 5400.0
union all
select '2022-04', 2, '570591', '成岳', '許', 'UUC0119', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-19', '12', '2022-04-19', '2022-05-31', '4800', 4800.0
union all
select '2022-04', 2, '570542', '浩軒', '陳', 'UUC0270', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-19', '1', '2022-04-19', '2022-04-19', '400', 400.0
union all
select '2022-04', 2, '570631', '仁怡', '張', 'UUC0651', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-04-19', '10', '2022-04-19', '2022-06-21', '3000', 3000.0
union all
select '2022-04', 2, '571126', '小瀚 Archie', '高', 'UUC0747', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-20', '18', '2022-04-19', '2022-05-12', '0', 0.0
union all
select '2022-04', 2, '571167', '延修', '陳', 'UUC0824', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-20', '2', '2022-04-19', '2022-04-20', '800', 800.0
union all
select '2022-04', 2, '571116', '樂言', '唐', 'UUC0916', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-20', '7', '2022-04-19', '2022-05-31', '2520', 2520.0
union all
select '2022-04', 2, '571125', '樂恆', '唐', 'UUC0938', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-20', '7', '2022-04-19', '2022-05-31', '2520', 2520.0
union all
select '2022-04', 2, '570475', '為霖', '羅', 'UUC0941', 'Roll-420', '中心輪滑課 (一小時) - 堂數', '2022-04-19', '3', '2022-04-19', '2022-04-21', '1260', 1260.0
union all
select '2022-04', 2, '570435', '為霖', '羅', 'UUC0941', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-19', '3', '2022-04-19', '2022-04-21', '1200', 1200.0
union all
select '2022-04', 2, '570453', '為善', '羅', 'UUC0950', 'Roll-420', '中心輪滑課 (一小時) - 堂數', '2022-04-19', '3', '2022-04-19', '2022-04-21', '1260', 1260.0
union all
select '2022-04', 2, '570431', '為善', '羅', 'UUC0950', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-19', '6', '2022-04-19', '2022-05-05', '2400', 2400.0
union all
select '2022-04', 2, '568400', '隽軒', '張', 'UUC1202', '12-C-1', '中心一對二 (一小時) - 堂數', '2022-04-12', '4', '2022-04-19', '2022-04-22', '2000', 2000.0
union all
select '2022-04', 2, '568398', '隽宇', '張', 'UUC1203', '12-C-1', '中心一對二 (一小時) - 堂數', '2022-04-12', '4', '2022-04-19', '2022-04-22', '2000', 2000.0
union all
select '2022-04', 2, '569523', '皓嚴', '鄭', 'UUC1229', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-16', '20', '2022-04-19', '2022-08-24', '7200', 7200.0
union all
select '2022-04', 2, '569662', '奕雯Abby ', '尤', 'UUC1335', 'OPIB-M-3', 'online小學中文IB課（75分鐘）-堂數', '2022-04-17', '10', '2022-04-19', '2022-06-21', '3750', 3750.0
union all
select '2022-04', 2, '570436', '浩權', '蕭', 'UUC1486', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-19', '10', '2022-04-19', '2022-06-21', '4000', 4000.0
union all
select '2022-04', 2, '571492', '思竣', '沈', 'UUC1514', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-21', '10', '2022-04-19', '2022-06-21', '4000', 4000.0
union all
select '2022-04', 2, '561477', '力衡', '俞', 'UUC1578', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-03-21', '10', '2022-04-19', '2022-06-21', '1500', 1500.0
union all
select '2022-04', 2, '570433', '凱朗', '林', 'UUC1590', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-19', '10', '2022-04-19', '2022-06-21', '4000', 4000.0
union all
select '2022-04', 2, '568369', '泓綽', '郭', 'UUC1644', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-12', '10', '2022-04-19', '2022-06-21', '4000', 4000.0
union all
select '2022-04', 2, '570561', '皓俊', '許', 'UUC1745', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-19', '20', '2022-04-19', '2022-05-18', '7200', 0.0
union all
select '2022-04', 1, '567013', '興道', '馬', 'UUC1741', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-06', '10', '2022-04-20', '2022-06-22', '1500', 0.0
union all
select '2022-04', 1, '569046', '奕勝', '林', 'UUC0023', 'ChIB-C-1', '中文IB課 (一個半小時) - 堂數', '2022-04-14', '10', '2022-04-20', '2022-06-22', '5400', 4860.0
union all
select '2022-04', 1, '571320', '子儁', '蔡', 'UUC0028', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-20', '10', '2022-04-20', '2022-05-20', '4000', 4000.0
union all
select '2022-04', 1, '571294', '澤謙', '蔡', 'UUC0029', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-20', '20', '2022-04-20', '2022-06-24', '7200', 7200.0
union all
select '2022-04', 1, '571266', '穎妍', '李', 'UUC0054', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-20', '20', '2022-04-20', '2022-08-31', '7200', 7200.0
union all
select '2022-04', 1, '571285', '卓峰', '李', 'UUC0056', 'ChIB-C-1', '中文IB課 (一個半小時) - 堂數', '2022-04-20', '10', '2022-04-20', '2022-06-22', '5400', 5400.0
union all
select '2022-04', 1, '569512', '心悅', '文', 'UUC0065', 'ChIB-C-1', '中文IB課 (一個半小時) - 堂數', '2022-04-16', '10', '2022-04-20', '2022-06-22', '5400', 5400.0
union all
select '2022-04', 1, '571206', '向澄', '任', 'UUC0095', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-20', '10', '2022-04-20', '2022-06-22', '4000', 4000.0
union all
select '2022-04', 1, '571210', '亦熙', '黃', 'UUC0179', 'ChIB-C-1', '中文IB課 (一個半小時) - 堂數', '2022-04-20', '10', '2022-04-20', '2022-06-22', '5400', 5400.0
union all
select '2022-04', 1, '571493', '子若', '陳', 'UUC0238', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-21', '2', '2022-04-20', '2022-04-21', '800', 800.0
union all
select '2022-04', 1, '571308', '浩然', '陳', 'UUC0251', 'ChIB-C-1', '中文IB課 (一個半小時) - 堂數', '2022-04-20', '10', '2022-04-20', '2022-05-11', '5400', 5400.0
union all
select '2022-04', 1, '571262', '浩軒', '陳', 'UUC0270', 'ChIB-C-1', '中文IB課 (一個半小時) - 堂數', '2022-04-20', '4', '2022-04-20', '2022-05-11', '2160', 2160.0
union all
select '2022-04', 1, '571280', '心翹', '呂', 'UUC0398', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-20', '20', '2022-04-20', '2022-08-31', '7200', 7200.0
union all
select '2022-04', 1, '569510', '靖祈', '鄧', 'UUC0588', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-16', '6', '2022-04-20', '2022-05-25', '2160', 2160.0
union all
select '2022-04', 1, '571283', '卓翹', '李', 'UUC0888', 'ChIB-C-1', '中文IB課 (一個半小時) - 堂數', '2022-04-20', '10', '2022-04-20', '2022-06-22', '5400', 5400.0
union all
select '2022-04', 1, '571325', '曉彤', '李', 'UUC0902', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-04-20', '10', '2022-04-20', '2022-06-22', '3000', 3000.0
union all
select '2022-04', 1, '569517', '珞頤', '陳', 'UUC0995', 'ChIB-C-1', '中文IB課 (一個半小時) - 堂數', '2022-04-16', '10', '2022-04-20', '2022-06-22', '5400', 5400.0
union all
select '2022-04', 1, '569511', '彥男', '鄧', 'UUC1076', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-16', '6', '2022-04-20', '2022-05-25', '2160', 2160.0
union all
select '2022-04', 1, '571487', '瑋柔', '曾', 'UUC1194', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-21', '20', '2022-04-20', '2022-08-31', '8000', 8000.0
union all
select '2022-04', 1, '571269', '千慧', '馮', 'UUC1334', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-20', '20', '2022-04-20', '2022-08-31', '7200', 7200.0
union all
select '2022-04', 1, '571264', '千博', '馮', 'UUC1371', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-20', '20', '2022-04-20', '2022-08-31', '7200', 7200.0
union all
select '2022-04', 1, '571129', '芯儀', '龐', 'UUC1374', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-20', '10', '2022-04-20', '2022-05-20', '1500', 1500.0
union all
select '2022-04', 1, '569519', '楚彤', '蕭', 'UUC1396', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-16', '20', '2022-04-20', '2022-06-25', '7200', 7200.0
union all
select '2022-04', 0, '569518', '茜而', '關', 'UUC0061', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-16', '20', '2022-04-21', '2022-06-22', '7200', 7200.0
union all
select '2022-04', 0, '571513', '梓軒', '徐', 'UUC0214', '11-C-2', '中心一對一 (一小時) - 堂數', '2022-04-21', '1', '2022-04-21', '2022-04-21', '800', 800.0
union all
select '2022-04', 0, '569532', '翼衡', '郭', 'UUC0241', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-16', '7', '2022-04-21', '2022-06-02', '2520', -480.0
union all
select '2022-04', 0, '569533', '翼婷', '郭', 'UUC0246', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-16', '6', '2022-04-21', '2022-05-26', '2160', 2160.0
union all
select '2022-04', 0, '564749', '嘉瓏', '何', 'UUC0248', '11-C-2', '中心一對一 (一小時) - 堂數', '2022-03-30', '10', '2022-04-21', '2022-05-30', '5000', 5000.0
union all
select '2022-04', 0, '570554', '聿熙', '王', 'UUC1021', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-19', '1', '2022-04-21', '2022-04-21', '400', 400.0
union all
select '2022-04', 0, '571300', '兆栩 ', '林', 'UUC1274', 'ZH-C-5', '綜合課 (一個半小時) - 堂數', '2022-04-20', '4', '2022-04-21', '2022-05-12', '2400', 2400.0
union all
select '2022-04', 0, '568614', '彥晨', '吳', 'UUC1555', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-13', '20', '2022-04-21', '2022-09-01', '7200', 7200.0
union all
select '2022-04', 0, '569416', '晞哲', '黃', 'UUC1653', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-15', '1', '2022-04-21', '2022-04-21', '400', 400.0
union all
select '2022-04', 0, '568937', '盈希', '陳', 'UUC1727', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-04-14', '5', '2022-04-21', '2022-05-19', '1500', 1500.0
union all
select '2022-04', 0, '571183', '凝思', '蔡', 'UUC1746', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-20', '2', '2022-04-21', '2022-04-28', '800', 0.0
union all
select '2022-04', -1, '568035', '家齊', '石', 'UUC0494', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-11', '10', '2022-04-22', '2022-05-30', '1500', 1500.0
union all
select '2022-04', -1, '568946', '倩蕎', '何', 'UUC0584', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-04-14', '10', '2022-04-22', '2022-06-24', '3000', 3000.0
union all
select '2022-04', -1, '569419', '昊洺', '劉', 'UUC1127', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-15', '20', '2022-04-22', '2022-09-09', '7200', 7200.0
union all
select '2022-04', -1, '571498', '皓嚴', '鄭', 'UUC1229', 'Roll-420', '中心輪滑課 (一小時) - 堂數', '2022-04-21', '10', '2022-04-22', '2022-06-24', '4200', 4200.0
union all
select '2022-04', -1, '571497', '伊俊', '鄭', 'UUC1230', 'Roll-420', '中心輪滑課 (一小時) - 堂數', '2022-04-21', '10', '2022-04-22', '2022-06-24', '4200', 4200.0
union all
select '2022-04', -1, '568341', '謙樂', '王', 'UUC1703', 'O11-C-1', 'Online 一對一 (半小時) - 堂數', '2022-04-12', '10', '2022-04-22', '2022-07-08', '3000', 3000.0
union all
select '2022-04', -2, '561790', '諾翹', '陳', 'UUC0011', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-03-22', '20', '2022-04-23', '2022-06-25', '7200', 7200.0
union all
select '2022-04', -2, '571530', '章玥', '韋', 'UUC0304', 'Roll-420', '中心輪滑課 (一小時) - 堂數', '2022-04-21', '10', '2022-04-23', '2022-06-25', '4200', 4200.0
union all
select '2022-04', -2, '570617', '澤揚', '彭', 'UUC0312', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-19', '20', '2022-04-23', '2022-09-03', '7200', 7200.0
union all
select '2022-04', -2, '570623', '琛揚', '彭', 'UUC0313', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-19', '10', '2022-04-23', '2022-06-25', '4000', 4000.0
union all
select '2022-04', -2, '571499', '欣恩', '鄭', 'UUC0410', 'Roll-420', '中心輪滑課 (一小時) - 堂數', '2022-04-21', '10', '2022-04-23', '2022-06-25', '4200', 4200.0
union all
select '2022-04', -2, '562760', '淳昕', '李', 'UUC0583', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-03-23', '3', '2022-04-23', '2022-05-07', '1080', 0.0
union all
select '2022-04', -2, '563927', '倬霆', '何', 'UUC1046', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-03-29', '10', '2022-04-23', '2022-06-23', '3600', 3600.0
union all
select '2022-04', -2, '567242', '希行', '鍾', 'UUC1184', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-07', '10', '2022-04-23', '2022-06-25', '4000', 4000.0
union all
select '2022-04', -2, '571229', '煒婷', '陳', 'UUC1534', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-20', '20', '2022-04-23', '2022-09-03', '7200', 7200.0
union all
select '2022-04', -2, '570585', '佳洛', '蔡', 'UUC1688', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-19', '10', '2022-04-23', '2022-06-25', '4000', 4000.0
union all
select '2022-04', -3, '571519', '梓軒', '徐', 'UUC0214', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-21', '20', '2022-04-24', '2022-08-23', '7200', 7200.0
union all
select '2022-04', -3, '568177', 'Anand', 'Annika', 'UUC1039', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-12', '20', '2022-04-24', '2022-09-04', '7200', 7200.0
union all
select '2022-04', -3, '536184', '彥彤', '林', 'UUC1591', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-01-06', '10', '2022-04-24', 'TBD', '4000', 0.0
union all
select '2022-04', -3, '568570', '佳靈', '白', 'UUC1743', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-13', '1', '2022-04-24', '2022-04-24', '400', 400.0
union all
select '2022-04', -3, '571374', '宇飛', '周', 'UUC1747', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-20', '1', '2022-04-24', '2022-04-24', '400', 400.0
union all
select '2022-04', -4, '568446', '楚康', '梁', 'UUC1742', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-12', '1', '2022-04-25', '2022-04-25', '400', 0.0
union all
select '2022-04', -4, '561791', '鎧盈', '陳', 'UUC0223', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-03-22', '10', '2022-04-25', '2022-07-11', '4000', 4000.0
union all
select '2022-04', -4, '571358', '心攸', '何', 'UUC0318', '12-C-1', '中心一對二 (一小時) - 堂數', '2022-04-20', '10', '2022-04-25', '2022-06-27', '5000', 5000.0
union all
select '2022-04', -4, '571357', '心怡', '何', 'UUC0329', '12-C-1', '中心一對二 (一小時) - 堂數', '2022-04-20', '10', '2022-04-25', '2022-07-11', '5000', 5000.0
union all
select '2022-04', -4, '571278', '延俊', '陳', 'UUC0930', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-20', '10', '2022-04-25', '2022-06-01', '4000', 4000.0
union all
select '2022-04', -4, '567923', '日晴', '吳', 'UUC1299', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-04-09', '10', '2022-04-25', '2022-07-11', '3000', 3000.0
union all
select '2022-04', -4, '571263', '峻灃', '鄭', 'UUC1316', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-20', '20', '2022-04-25', '2022-05-23', '3000', 3000.0
union all
select '2022-04', -4, '568955', '懃', '劉', 'UUC1664', '11-C-2', '中心一對一 (一小時) - 堂數', '2022-04-14', '10', '2022-04-25', '2022-06-27', '8000', 8000.0
union all
select '2022-04', -5, '571207', '凱瞳', '楊', 'UUC0044', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-20', '20', '2022-04-26', '2022-09-06', '7200', 7200.0
union all
select '2022-04', -5, '568950', '泳淇', '陳', 'UUC0739', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-14', '20', '2022-04-26', '2022-09-06', '7200', 7200.0
union all
select '2022-04', -5, '569659', '頌曦', '林', 'UUC1216', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-17', '20', '2022-04-26', '2022-09-06', '7200', 7200.0
union all
select '2022-04', -5, '569524', '伊俊', '鄭', 'UUC1230', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-16', '20', '2022-04-26', '2022-06-30', '7200', 7200.0
union all
select '2022-04', -5, '570587', '鳴希', '馬', 'UUC1676', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-19', '20', '2022-04-26', '2022-09-06', '7200', 7200.0
union all
select '2022-04', -6, '571471', '晉光', '余', 'UUC0103', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-04-21', '3', '2022-04-27', '2022-05-11', '900', 900.0
union all
select '2022-04', -6, '569421', '維廷', '高', 'UUC0286', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-15', '1', '2022-04-27', '2022-04-27', '400', 400.0
union all
select '2022-04', -6, '569422', '維承', '高', 'UUC0287', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-15', '1', '2022-04-27', '2022-04-27', '400', 400.0
union all
select '2022-04', -6, '568934', '逸峰', '陳', 'UUC0453', 'ChIB-C-1', '中文IB課 (一個半小時) - 堂數', '2022-04-14', '10', '2022-04-27', '2022-06-29', '5400', 5400.0
union all
select '2022-04', -6, '568555', '適妤', '溫', 'UUC0508', 'OK-C-1', 'Online 幼兒小組課 (半小時) - 堂數', '2022-04-13', '10', '2022-04-27', '2022-06-29', '1500', 1500.0
union all
select '2022-04', -6, '570611', '彥博', '李', 'UUC0851', 'ChIB-C-1', '中文IB課 (一個半小時) - 堂數', '2022-04-19', '10', '2022-04-27', '2022-06-29', '5400', 5400.0
union all
select '2022-04', -6, '571534', '倩而', '葉', 'UUC0898', 'ChIB-C-1', '中文IB課 (一個半小時) - 堂數', '2022-04-21', '10', '2022-04-27', '2022-06-29', '5400', 5400.0
union all
select '2022-04', -6, '568403', '隽軒', '張', 'UUC1202', '12-C-2', '中心一對二 (一個半小時) - 堂數', '2022-04-12', '10', '2022-04-27', '2022-06-29', '7500', 7500.0
union all
select '2022-04', -6, '568392', '隽宇', '張', 'UUC1203', '12-C-2', '中心一對二 (一個半小時) - 堂數', '2022-04-12', '10', '2022-04-27', '2022-06-29', '7500', 7500.0
union all
select '2022-04', -6, '571199', '籽叡', '陳', 'UUC1376', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-20', '20', '2022-04-27', '2022-09-07', '7200', 7200.0
union all
select '2022-04', -6, '569418', '逸嵐', '余', 'UUC1598', 'ZH-C-3', '綜合課 (一小時) - 堂數', '2022-04-15', '10', '2022-04-27', '2022-06-29', '4000', 4000.0
union all
select '2022-04', -8, '568656', '鉻然', '蕭', 'UUC1001', '11-C-2', '中心一對一 (一小時) - 堂數', '2022-04-13', '10', '2022-04-29', '2022-07-08', '8000', 8000.0
union all
select '2022-04', -8, '568590', '謙睿', '董', 'UUC1294', 'O11-C-3', 'Online 一對一 (一小時) - 堂數', '2022-04-13', '10', '2022-04-29', '2022-07-08', '6000', 0.0
union all
select '2022-04', -9, '567446', '俊彥', '劉', 'UUC0694', 'OPIB-C-1', 'Online 小學中文IB課 (一小時) - 堂數', '2022-04-08', '10', '2022-04-30', '2022-07-02', '3000', 3000.0;

select 'dbr.subtitle', 'Oustanding product sales payment';

select 'dbr.sum', 'Outstanding amount';

select '逸詩' as 'First name', '黃' as 'Last name', 'MISC004' as 'Product code', 'KPCC' as 'Product name(Eng)', '500' as 'Payable total', 0.0 as 'Outstanding amount', '2022-04-06' as 'Order date'
union all
select '皓俊', '許', 'MISC002', '書本費', '850', 0.0, '2022-04-19';
myDBR Team, Key Master

Hi,
there seems to be a bug in the Excel library. We'll take a look at it.

The bug is triggered by your column 'Tuition total' which is (based on the name) assumed to be a number but is a string.

If you select cast(`Tuition total` as signed) instead of `Tuition total`, (or add a space at the end of the string) the Excel export works ok.

--
myDBR Team
myDBR Team, Key Master

Hi,
the bug in the Excel library has now been fixed. Your original report works now without changes.

--
myDBR Team
jasmondluk, Member

Thanks

Reply

You must log in to post.