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'"
Tuesday, March 20, 2012
crystal reports 8.5
Labels:
crystal,
customerid,
database,
microsoft,
mysql,
oracle,
query,
reports,
server,
serverselect,
sql,
startdatetimegt,
v_verifiedtrips
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment