本文介绍了使用外键链接Crystal Report中的多个表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
你好,
我是Crystal报道的新手。我有2张主键和外键表
客户详情
EID - 主键
PurchaseDetails
PNo-Primary Key
PDate,
EID- Foreigh Key
NetAmount
报告查询用c#写的
Hello ,
i'm New to Crystal report. i have 2 tables with primary and foreign key
Customer Details
EID - Primary Key
PurchaseDetails
PNo-Primary Key
PDate,
EID- Foreigh Key
NetAmount
Report Query written in c#
SELECT DISTINCT P.PNo, P.PDate, P.PM, P.DisAmt, P.LT, P.NT, P.EID, P.PTime, C.EName FROM PurchaseDetails AS P INNER JOIN CustomerDetails AS C ON P.EID = C.EID
报告基于自动链接的密钥。
但是报告数据没有显示
你能不能告诉我解决方案。非常紧急!
In Report Automattically linked based key.
but report data not showing
can u plz anyone tell me solution for this . its very urgent!
推荐答案
这篇关于使用外键链接Crystal Report中的多个表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!