Loading

How to prevent the Repeated Data?

srinivas P

Hi,
I have a Problem in Crystal Reports.
My Requirement is

I have two tables
1)Information

InfoId	InfoEng	datatype
1	ArticleNo	number
2	Name	nvarchar(max)

2)eAppPrintInfo

eAppcode	sbujectid	Infoid	printinfo
120	150	1	123456
120	150	2	nivas

i want to Printinfo for user based on Infoid

Ex:i want to display value of name(Here name.Article no ale lables)
printinfo is value of that lables.
How to get data based on infoId using Crystal report viewer.

Thanks inadvance

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jiteendra Sampathirao15y ago
Hi,
write this query:

SELECT DISTINCT a.printinfo FROM a.Information, b.eAppPrintInfo where a.Infoid=b.Infoid;

hope it help you.....