How To Write Formula In CR 8.0
hay
I am using Vb 6.0 And Crystal Report 8
And I am Trying to Make A formula For Display record According To This Criteria
First Select CustomerId
Then Select only Those in Which Date is Between dtFrom to dtTo
i have tryed my best but whole record of customerid is shown not Between dtFrom To dtTo
is any one can help me
Thanks
Re: How To Write Formula In CR 8.0
You would need to have your report already designed correctly so all you have to do is set the selection formula for either record or group.
You can do something like this, just add in more code for passing parameters of the dates.
Code:
oRpt.RecordSelectionFormula = "({Table1.CustomerId} = iCustomerID) AND
(({Table1.DueDate} >= DateTime (2008, 1, 29, 12, 42, 53)) AND ({Table1.DueDate} <= DateTime (2008, 1, 29, 12, 42, 53)))"
Re: How To Write Formula In CR 8.0
I want to ask one thing more
i want to use these variable to the parameters to CR
first is CustomerID
second is DtFrom
third is DtTo
then how is the statement will be
AND
which type of Date Format Should i used in database and in veriables
Thanks
Re: How To Write Formula In CR 8.0