Print Page | Close Window

sql conversion Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7353 Printed Date: 02 May 2024 at 10:42am Topic: sql conversion Posted By: wregnier Subject: sql conversion Date Posted: 12 Aug 2009 at 8:12am Trying to convert an sql query statement and adapt it to a report. Can some one provide some guidance of how this can be done? Here is the query that I'd like to adapt. SELECT     WK_ID_CODE FROM        f_Personnel WHERE     (WK_PK NOT IN                           (SELECT     FWOR_WK_FK                             FROM          f_WO_Labor                             WHERE      (FWOR_TRANS_DATE = '7/6/2009'))) Thanks for your help!! Wayne Replies: Posted By: DBlank Date Posted: 12 Aug 2009 at 2:15pm YOu should be able to use that straight in a Command.

Print Page | Close Window