Skip to Content
0
Former Member
Oct 21, 2011 at 10:54 AM

Crystal Report

20 Views

APinvoice Query

SELECT DISTINCT(T0.[DocNum]) AS 'GRN NO', T0.[DocDate] AS 'GRN DATE', T0.[CardName] AS 'NAME OF THE PARTY', T1.[ItemCode] AS 'PART NO', T1.[Dscription] AS 'PART DESCRIPTION', T1.[Quantity], T1.[Price], T1.[LineTotal] AS 'BASE AMOUNT',

T1.[LineTotal]+t1.[VatSum] as'TOTAL', T0.[DocStatus], T0.[UserSign]

FROM OPCH T0 INNER JOIN PCH1 T1 ON T0.DocEntry = T1.DocEntry

INNER JOIN OITM T4 ON T1. ItemCode = T4. ItemCode INNER JOIN OITB T5 ON T4.ItmsGrpCod = T5.ItmsGrpCod

INNER JOIN OCRD T3 ON T3.CardCode=T0.CardCode

WHERE T0.[DocDate] >=[%0] AND T0.[DocDate] <=[%1] AND t4.ItmsGrpCod <>'111' AND (T5.[ItmsGrpNam]='[%3]' OR '[%3]'=' ') AND (T3.[CardName]='[%4]' OR '[%4]'=' ' ) AND T1.[BaseType]<>'21' AND (T0.[DocStatus]='[%5]' OR '[%5]'=' ' )

ORDER BY T0.[DocDate], T0.[DocNum]

Now i want to create a formula field in crystal report so pls explain How do i create

Formula field With parameter

Explain step by step , advance thanks