使用外键链接Crystal Report中的多个表 [英] Link Multiple Tables in Crystal Report with Foreign Key

问题描述

你好，



我是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中的多个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！