回答：Windows高分屏下设计器显示问题- FineReport帮助文档 - 全面的报表使用教程和学习资料 (fanruan.com)

回答：select count(chejian),xingming from 表 group by xingming

回答：别用left和right函数，用mid函数mid("原因",1,find(",","原因"))

回答：with t1 as (  select cast('20240101 00:00:00' as datetime) as fdate,56 as fnum union all select cast('20241231 00:00:00' as datetime) as fdate,36 as fnum union all select cast('20240221 00:00:00' as datetime) as fdate,68 as fnum union all select cast('20240518 00:00:00' as datetime) as fdate,19 as fnum union all select cast('20240815 00:00:00' as datetime) as fdate,82 as fnum union all select cast('20240423 00:00:00' as datetime) as fdate,73 as fnum)select  --当年最后一天零点  sum(case when fdate=dateadd(year,datediff(year,0,dateadd(year,1,getdate())),-1) and fnum is not null then fnum else 0 end) - --当年第一天零点  sum(case when fdate=dateadd(yy,datediff(yy,0,getdate()),0) and fnum is not null then fnum else 0 end) as fczfrom t1

回答：SELECT (TIME '12:00:00' - TIME '10:00:00') / INTERVAL '1 minute'

回答：sql.rar

回答：你看你的数据是不是都是大于200或者小于0，超出范围了，所以看不见

回答：你的那个有白色的边框，去掉

回答：数据字典取值不要用同一个数据集里面的，再加两个数据集出来

回答：你是怎么除的，公式看一下