Crystal Report中按字段分组的问题 [英] Problem with group by field in Crystal Report

问题描述

我有一个购买表，字段是 - ：

 pro_name，batch，exp_dt，drg_mfg，qty，mrp，pur_amt，pur_Date 

我希望它在这样的水晶报告中显示（这里pur_date可能重复）

pur_date

 pro_name ，batch，exp_dt，drg_mfg，qty，mrp，pur_amt 

和sum（显示在每个不同的pur_date详细信息页脚中）的qty，mrp，pur_amt以及总计（在报告页脚中显示qty，mrp，pur_amt ..



我的问题是：当我使用pur_date创建带有group by子句的水晶报表时，它显示为这样

1/27/2013

包含重复pur_dates的所有记录详细信息......



我是在winform中使用它...

感谢您的帮助......

解决方案

您最好更改您的桌面设计以进行交易：像这个TranHead和TranLine ..在TranHead只有购买日期，供应商名称，TrType，UserDateTime，用户，比尔N o等等只有SKU，Qty，Rate，Vat等的TranLine。然后你可以得到一个很好的输出水晶报告，网格等。这个表格所做的所有交易，例如：购买，发票，估计，拒绝等。这里TrType是PUR，INV，EST，REJ...... enjoyyyyy

I have a purchase table and the fields are -:

pro_name,batch,exp_dt,drg_mfg,qty,mrp,pur_amt,pur_Date

I want it show in crystal report like this(Here pur_date may be duplicate)
pur_date

pro_name,batch,exp_dt,drg_mfg,qty,mrp,pur_amt

and sum(which show in every distinct pur_date details footer) of qty,mrp,pur_amt and also grand total(which show in report footer) of qty,mrp,pur_amt..

my problem is: when i create crystal report with group by clause with pur_date it shows like this
1/27/2013
all the records details with duplicate pur_dates...

I''m using it in winform...
Thanks for every help......

解决方案

You better change your table design for Transaction: Like this TranHead and TranLine.. In TranHead having only Purchase Date, Vendor Name,TrType, UserDateTime, User, Bill No etc. In TranLine having only SKU, Qty, Rate , Vat, etc etc . then u can get a good out put in crystal reports, grid etc. All transactions made by this tables eg: Purchase, Invoice, Estimate, Rejections etc.. Here TrType is "PUR, INV, EST, REJ"...enjoyyyyy

这篇关于Crystal Report中按字段分组的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！