1. 

   jasmondluk, Member

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

   select 'DBR.text' as 'DBR.text', 'Agatha Learning Community (Jordan)' as 'group_concat( centername )';

   select 'dbr.text', 'From: 2021-11-01 to 2021-11-30';
   select 'dbr.text', 'Please note that makeup arrangement will not change the incure date of class fee. 請留意，延後補課安排不會改變原先課堂的盈利確認日期';

   select 'dbr.search', 1;

   select 'dbr.subtitle', 'Monthly Revenue/Payment received 每月盈利/收款';

   select 'dbr.crosstab', 'Payment/Revenue month 月份';
   select 'dbr.hsum', '[value]';

   select 'dbr.colstyle', '[value]', '[white-space:pre; width:1000]';
   select 'dbr.colstyle', 'Type 類別', '[white-space:nowrap]';

   select '1 - Revenue 盈利 (all invoice 全部發票) ' as 'Type 類別', '2021-11' as 'Payment/Revenue month 月份', 305604.0 as '[value]'
   union all
   select '2 - Revenue 盈利 (paid invoice 只包括已繳款發票)', '2021-11', 151956.0
   union all
   select '3 - Payment received 收款 ', '2021-11', 71500.0;

   select 'dbr.chart', 'MSline', 'Chart 圖表', 1500, 500;

   select '202111' as 'Financial_month', '1 - Revenue 盈利 (all invoice 全部發票) ' as 'type', 305604.0 as '[value]'
   union all
   select '202111', '2 - Revenue 盈利 (paid invoice 只包括已繳款發票)', 151956.0
   union all
   select '202111', '3 - Payment received 收款 ', 71500.0;
2. 

   myDBR Team, Key Master

   What is the version/build you are using?

   Run the automatic updater and try again. The texts should show up both in Excel and PDF exports.

   Btw, if you have multiseries line charts with data that has just one serie (202111 in this case), you might want to use markers for the data. The lines are drawn between the categories within the series. Now that you only have only one category per serie, the width of the line is zero. To show the values, you can use a marker.

   select 'dbr.chart.options', 'marker', null, 'CircleShape', 10;

   --
   myDBR Team

Reply

You must log in to post.