Tuesday, March 20, 2012

crystal reports 8.5

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