Crystal Report XI - TechRepublic
General discussion
January 23, 2006 at 02:21 AM
naturale02

Crystal Report XI

by naturale02 . Updated 20 years, 5 months ago

I am new to CR, i hav a problem here,
from sql query, the syntax is like this:
SELECT COUNT(*) AS Expr1
FROm MTSent a INNER JOIN
DNReceived b ON a.InfraTxnID = b.InfraTxnID
WHERE (a.ContentCode = ‘4597’)AND(a.MediaCode = ‘501’)AND(a.shortcode = ‘32330’) AND(a.Telco = ‘celcom’)
Hw do i make this statement on CR? using formula or parameter or running total field?
many thks to all

This discussion is locked

All Comments