回答:扩大一下页面纸张大小试试呢
回答:导出后的文件 就不受控制了,除非你系统中的导出只是一个类似预览的按钮,点击导出跳转到一个网页链接查看PDF文件内容,不提供下载到本地的功能.
回答:已提供模板文件。
回答:INARRAY(ABS(K6), SORTARRAY(ABS(K6)))
回答:WITH a AS (
SELECT 1 AS id, CAST('2024-09-13 09:00:00' AS DATETIME) AS tm
UNION ALL
SELECT 2, CAST('2024-09-13 12:05:00' AS DATETIME)
UNION ALL
SELECT 3, CAST('2024-09-13 13:50:00' AS DATETIME)
UNION ALL
SELECT 4, CAST('2024-09-13 14:15:00' AS DATETIME)
UNION ALL
SELECT 5, CAST('2024-09-13 14:20:00' AS DATETIME)
UNION ALL
SELECT 6, CAST('2024-09-13 18:45:00' AS DATETIME)
),
b AS (
SELECT
id,
tm,
LAG(tm) OVER (ORDER BY id) AS prev_tm
FROM
a
),
c AS (
SELECT
id,
tm,
prev_tm,
CASE
WHEN CAST(prev_tm AS TIME) <= '12:40:00' AND CAST(tm AS TIME) >= '13:40:00' THEN
DATEDIFF(MINUTE, CAST(prev_tm AS DATETIME), CAST('13:40:00' AS DATETIME))
+ DATEDIFF(MINUTE, CAST('14:00:00' AS DATETIME), tm)
WHEN CAST(prev_tm AS TIME) > '12:40:00' AND CAST(prev_tm AS TIME) < '13:40:00' THEN
DATEDIFF(MINUTE, CAST('14:00:00' AS DATETIME), tm)
ELSE
DATEDIFF(MINUTE, prev_tm, tm)
END AS adjusted_time_diff
FROM
b
)
SELECT
id,
tm,
prev_tm,
adjusted_time_diff
FROM
c
ORDER BY
id;
回答:WorkBook19.rar
回答:减少一下数据查询数量,看看效果,是不是某些数据重复展示了,导致数据量过大触发保护机制.
回答:发模板吧 你这个要调整父格和过滤条件等
回答:在数据同步里面写查询嵌套查询是一样的吧,只要数据库是同一个。
回答:https://help.fanruan.com/finereport/doc-view-4055.html?source=4 https://help.fanruan.com/finereport/doc-view-1195.html?source=4# 参考
324
324
11
10