使用TWO表的Crystal Report [英] Crystal Report using TWO tables
问题描述
我有一个类似SQL的查询...
I have an SQLquery like...
select PurchaseDetails.order_no, PurchaseDetails.order_date, PurchaseDetails.sup_name, PurchaseDetailsCHILD.Prod_name,PurchaseDetailsCHILD.prod_qty,PurchaseDetailsCHILD.Amt_per_piece,PurchaseDetails.VAT,PurchaseDetails.Discount,PurchaseDetails.Netamt
from PurchaseDetailsCHILD join PurchaseDetails
on PurchaseDetails.Purchd_id = PurchaseDetailsCHILD.Purchd_id
当我填写我的数据表它只包含两个记录 ...但是在我将它设置为我的数据源之后......
While i fill my datatable it contains only two records...But after i set it as my datasource like...
rpt.SetDataSource(myDatatable); //here is the datatable contains result of my query
CrystalReportViewer1.ReportSource = rpt;
显示记录两次（创建重复记录）....
即使我在我的表格中插入另一行后检查....
如果我的数据表包含三个记录那么我的crystalrpt包含八个记录。
我在crystalreport DatabaseFields中有两个不同的表通过引用PURCHD_ID。我不知道它是如何假设他们的链接...即使我删除了这些链接（在数据库专家 - >链接标签中）它没有用...
最后我通过删除行rpt.SetDataSource（myDatatable）;进行检查。它的工作正常....但我需要的是，我正在动态传递查询。实际上我只需通过此数据表过滤查询结果。所以，我需要它。
请给我你的建议....
It displays the records twice(Creating duplicate records)....
Even i check after inserting another row in my table....
if my datatable contains three records then my crystalrpt contains Eight records.
I'm having two different tables inside my crystalreport DatabaseFields by refering PURCHD_ID. I don't know how it assume's their links...Even i deleted those links(in "Database Expert"--> "link" tab) it didnt work...
As finally i made a check by remove the line "rpt.SetDataSource(myDatatable);". Its works fine....but what i need is, i'm dynamically passing query. Actually i need filter the Query results through this Datatable only. So, i need it.
Please give me your suggestions....
推荐答案
在这里你去
重复
水晶报告：删除重复值 [ ^ ]
处理重复记录或表格膨胀 [ ^ ]
排除Crystal Reports中的重复记录 [ ^ ]
Gro上
如何在Crystal Reports中使用分组 [ ^ ]
Here you go
Duplicates
Crystal Reports: Remove Duplicate Values[^]
Dealing with duplicate records or "table inflation"[^]
Troubleshooting "Duplicate Records" in Crystal Reports[^]
Group
How to Use Grouping in Crystal Reports[^]
我可以尝试水晶报告
文件 - >报告选项，然后选中选择不同的记录。
或
确保你的PurchaseDetailsCHILD没有重复键。 （通常我们加入PurchaseHeader）
My be you could try on crystal report
File -> Report Option , then "check on" "Select Distinct Records".
or
make sure your PurchaseDetailsCHILD have no repeat key. (usually we join with PurchaseHeader)
这篇关于使用TWO表的Crystal Report的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
