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 conversation is currently closed to new comments.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Crystal Report XI
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