Hi all,
This is my query in SQL Server
select customerid from v_verifiedtrips where startdatetime>'7/1/2005' and
enddatetime<'7/31/2005' and customerid not in (
select customerid from v_verifiedtrips where startdatetime>'6/1/2005' and enddatetime<'6/31/2005')
Could any one help me out in writing formula in Crystal reports 8.5 using above queryDid you mean selection formula?
CR.selectionFormula="startdatetime>'6/1/2005' and enddatetime<'6/31/2005'"
No comments:
Post a Comment