如何在水晶报表x1中的交叉表中添加列？ [英] How do I add columns to a cross tab in crystal reports x1?

问题描述

HI，我正在使用Crystal报告版x1。我无法在交叉表中看到要使用的计算字段。



我创建了一个交叉表，显示FAQ标题用于的标签的次数一个月或多个月。列标题中显示月份，常见问题标题显示在行中。总结字段是crystal_txt的计数。标题



如果FAQ标题显示为7月16日使用的681次，那么我想在此旁边添加另一列一个有30个，另一个旁边有一个显示结果681 - 30即651.



然后我想显示另一个有17.60美元的列然后另一列有总费用，即$ 17.60 x 651 = $ 11457.60



用于月份门槛的费用费用总费用

常见问题解答标题681 30 651 $ 17.60每个$ 11457.60



每个月会有多行使用不同的用途。



谢谢，



马克



我的尝试：



我试图找到一个在Cross选项卡中使用的计算字段，我认为版本14可能有它而不是版本x1。

I am using Crystal reports version x1. I can't see a calculated field to use in the cross tab.

I have a created a cross tab that shows the number of times an FAQ Title is used for either one month or multiple months. The months are shown in the Column heading and the FAQ Title is shown in the Rows. The summarized field is a count of crystal_txt.Title

If an FAQ Title is showing say 681 times used for July-16 then I want to add another column next to this one that has 30 in it and another column next to this that shows the result of 681 - 30 ie 651.

Then I want to show another column that has $17.60 and then another column that has the total cost ie $17.60 x 651 = $11457.60

times used by month threshold chargeable Cost Total cost
FAQ Title 681 30 651 $17.60 each $11457.60

There would be multiple rows each with a different usage by month.

Thanks,

Mark

What I have tried:

I ave tried to find a Calculated Field to use in the Cross tab, I think version 14 may have it but not version x1.

推荐答案

17.60然后是另一列总成本，即

17.60 and then another column that has the total cost ie

17.60 x 651 =

17.60 x 651 =

11457.60



按月使用的次数阈值应付费用总费用

FAQ标题681 30 651

11457.60

times used by month threshold chargeable Cost Total cost
FAQ Title 681 30 651

这篇关于如何在水晶报表x1中的交叉表中添加列？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！