抑制后在摘要中添加重复值 [英] Duplicated values added in summary after suppress that

问题描述

我必须汇总Crystal报表中的Amount字段.我在公式部分的专家中给出了抑制重复行的公式.
我使用了子报表.如果我总结这些字段，则添加重复项
行场也.但是我不想在摘要中添加重复的值.如果有人知道该怎么做，请帮助我.



谢谢

Hi,

I have to summary Amount fields in crystal reports.I gave formula to suppress duplicate row in details section expert.
I used subreport. If i summarize these fields its added duplicate
row field also. But i dont want to add duplicate value in summary. If anybody know how to do this please help me.



Thanks

推荐答案

如果要格式化报表，以使重复的值不会在页面上重复，请使用字段格式设置选项.

如果在详细信息"部分中，则可以:

右键单击该字段，然后选择格式字段"菜单.

勾选显示以下内容的框:禁止重复显示

If you want to format the report so that duplicated values are not repeated down the page, use the field formatting option.

If it is in the Details section, you can:

Right click on the field, and select the "Format Field" menu.

Tick the Box that says: Suppress if duplicated

我在详细信息部分专家中使用了此公式-禁止(不向下钻取)

Hi,

I used this formula in details section expert - Suppress(No Drill down)

//It will suppress whole row
if {DataTable1.coverid}=next({DataTable1.coverid}) then
(
    if {DataTable1.buyccy} = next({DataTable1.buyccy}) or {DataTable1.sellccy}=next({DataTable1.sellccy}) or {DataTable1.matdate1}=next({DataTable1.matdate1}) or {DataTable1.matdate2}=next({DataTable1.matdate2}) or {DataTable1.pfname}=next({DataTable1.pfname})then
    (
        true
    )
)

然后我用了子报表.运行良好.

谢谢

then i used subreport. It''s working well.

Thanks

这篇关于抑制后在摘要中添加重复值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！