Crystal报告交叉表中的零值 [英] Crystal reports Zero values in crosstab
问题描述
使用Crystal Reports 2008
我需要创建交叉表报告,因为即使没有数据,我也必须显示所有行和所有列对于特定组合
行是{ISSUE.STATUS}(例如:打开,关闭,待定,暂停)
列是{ INVOICE.DONE}(例如:是,否)
摘要是已开票和未开票的问题。
当前输出:
----------是----否
开放----- 15 ----- 0
关闭---- 3 ------ 8
交叉表报告抑制零并仅显示打开和关闭。
我怎样才能每次都获得所有行和所有列。
所需输出:
--------------是-----否
打开--------- 15 ----- 0
关闭-------- 3 ------- 8
待定------- 0 ------ 0
暂停---- 0 ------ 0
感谢您的所有建议!!
Using Crystal Reports 2008
I need to create a crosstab report, in that I have to show all the rows and all the columns even if there is no data for a particular combination
The Rows is {ISSUE.STATUS} (eg: Open, Closed, Pending, Suspended)
Columns is {INVOICE.DONE} (eg: Yes, No)
Summary is count of Invoiced and UnInvoiced Issues.
Current output:
----------Yes----No
Open-----15-----0
Closed----3------8
Crosstab report is suppressing zeroes and showing only Open and Close.
How can I get all rows and all columns every time.
Desired output:
--------------Yes-----No
Open---------15-----0
Closed--------3-------8
Pending-------0------0
Suspended----0------0
Thank You for all advice!!
推荐答案
取消选中如果为零则禁止 [ ^ ]选项
撤消抑制交叉表中的空字段 [< a href =http://stackoverflow.com/questions/6094574/suppressing-empty-fields-in-crosstabtarget =_ blanktitle =New Window> ^ ]
还要检查
抑制交叉表数据 [ ^ ]
Uncheck Suppress if Zero[^] option
Undo Suppressing empty fields in crosstab[^]
Also check
Suppressing Cross-Tab Data[^]
这篇关于Crystal报告交叉表中的零值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!