水晶报表合并重复的列相同的数据 [英] Crystal reports merge duplicate columns same data

问题描述

是否有一个公式:

mainId    productId   groupId    product       price        qty
456         123        555         book          10          2
456         789        555         book          10          2
222         125        888         pencil        20          5         
222         125        859         pencil        20          1

它显示(从子报告到主报告):

it shows (from sub report to main report):

product: book
Computation: 10x2     20

product: book
Computation: 10x2     20

Total                 40

如果数据生成与上述相同，我希望结果是这样的:

I want the result to be like this if data produce are the same like the one above:

product: book
Computation: 10x4     40

Total                 40

如果数据与mainId 222不同，则结果应如下所示:

if not the same data like with the mainId 222 the result should be like this:

product: pencil
Computation: 20x5     100

product: pencil
Computation: 20x1     20

Total                120

在子报告中，我按productId分组

In sub report I group it by productId

Group Header: [Group#1 Name]
Details:
Group Footer: [product]
Computation:  [computation (10x2)]   [total (20)]

在主报告中，我也按productId对其进行分组.我将子报表"分组在组头"中.在页面页脚中是总计20.

In main report I group it by productId too. I group the Subreport in Group Header. In the Page Footer is the Grand Total which is 20.

推荐答案

看起来您应该对GroupID而不是productid进行分组?

looks like you should group on GroupID rather than productid?

这篇关于水晶报表合并重复的列相同的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！