Crystal报表总和运行总跳过重复记录 [英] Crystal report sum running total skip duplicate record

问题描述

我正在使用Crystal Report 9

i有表格xx

和记录

I'm Using Crystal Report 9
i have table xx
and Records

branch   number   val
1         50    200
5         2     150
1         1     200
3         4     300

i using分组

和报告页脚我使用总计金额

总和我想跳过重复记录如

i using group
and in Report footer i use running total sum
in sum i want to skip duplicate record like

branch   number   val
1         50      200
5         2       150
3         4       300
----------------------
total             650

我尝试过：



i尝试

What I have tried:

i tried

{number} = Previous ({number}) 

推荐答案

请先阅读我的评论。你必须修改你的SQL语句才能得到预期的结果。



看看下面的例子：

Please, read my comment first. You have to modify your SQL statement to be able to get result as expected.

Take a look at below example:

DECLARE @tmp TABLE (branch INT, number INT, val INT)

INSERT INTO @tmp (branch, number, val)
VALUES(1, 50, 200),
(5, 2, 150),
(1, 1, 200),
(3, 4, 300)

SELECT DISTINCT [branch], MAX([number]) OVER (PARTITION BY [branch] ORDER BY number DESC) AS [number],  [val]
FROM @tmp

结果：

Result:

branch	number	val
1		50		200
3		4		300
5		2		150

这篇关于Crystal报表总和运行总跳过重复记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！