1. 

   jasmondluk, Member

   screen captures

   select 'dbr.export.options', 'autosize', 1;

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

   select 'dbr.resultclass', 'align_left';

   select 'dbr.export.options', 'orientation', 'landscape';

   select 'dbr.css', 'div.title {font-size:24px }';
   select 'dbr.css', 'div.left_text { text-align: left; font-size:12px }';
   select 'dbr.css', 'div.left_text_red { color:red; text-align: left; font-size:12px }';

   select 'DBR.text' as 'DBR.text', '導師: 7100古路華老師 ' as 'v_teacher', 'left_text_red' as 'left_text_red';

   select 'dbr.text', '月份:10/2023', 'left_text';
   select 'dbr.text', '';

   select 'dbr.resultclass', 'align_left';

   select 'dbr.search', 0;

   select 'OYO1001' as '課程編號', 'Yoga(ID:36394)' as '班期名稱', '成人瑜伽班' as '課程名稱', 'Tue(18:30-20:00)' as '上課日期';

   select 'dbr.summary.options', 'limit_summary_level', 2;
   select 'dbr.summary.text', '總數';

   select 'dbr.resultclass', 'align_left';

   select 'dbr.search', 0;

   select '本月課堂' as '計算類別', '2023-09-05' as '付款日期', '16080001' as '學生編號', '楊美玲 YEUNG MEI LING' as '學生姓名', 250.0 as '費用', 4 as '總堂數', '3/10,10/10,17/10,24/10' as '課堂日子', 'MS TSANG' as '員工', '' as '備註'
   union all
   select '本月課堂', '2023-09-05', '13100065', '胡紫萍 WU CHI PING', 250.0, 4, '3/10,10/10,17/10,24/10', 'MS TSANG', ''
   union all
   select '本月課堂', '2023-08-31', '13100068', '薜惠玲 SIT WAI LING', 250.0, 4, '3/10,10/10,17/10,24/10', 'MS TSANG', ''
   union all
   select '本月課堂', '2023-08-31', '13100069', '薜惠珍 SIT WAI CHUN', 250.0, 4, '3/10,10/10,17/10,24/10', 'MS TSANG', ''
   union all
   select '本月課堂', '2023-09-05', '18070005', '賴明怡 LAI MING YEE', 250.0, 4, '3/10,10/10,17/10,24/10', 'MS TSANG', ''
   union all
   select '本月課堂', '2023-09-05', '13100070', '陳玉瓊 CHAN YUK KING', 250.0, 4, '3/10,10/10,17/10,24/10', 'MS TSANG', '';

   select 'dbr.resultclass', 'align_left';

   select 'dbr.search', 0;

   select '$1,500.00' as 'Tuition fee', '62%' as 'Rate', '$930.00' as 'Tutor Share';
2. 

   myDBR Team, Key Master

   Excel does not support CSS classes. myDBR has support for basic CSS style conversion for Excel styles.

   Instead of dbr.text you can use dbr.divify which supports CSS styles:

   select 'dbr.divify', 'align_l';
   
   select 'dbr.colstyle', 'txt', '[color:red;font-size:12px]';
   
   select '導師: 7100古路華老師 ' as 'txt';
   
   

   Make sure you use the latest build though.

   --
   myDBR Team

Reply

You must log in to post.