Showing posts with label customerid. Show all posts
Showing posts with label customerid. Show all posts

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'"