Crystal Report SQL ?

Hi, I'm new doing crystal report so I do not get where the error is.. So please help me if possible..

This is a project handed down, I'm not the one coding the program..

I have run the SQL Statement at the SQL Query and IT WORKS !
Cause i need to add another condition to it and its added into the WHERE clause.

The report which contains 2 subreports uses the SQL statement.
When i run the VB application, no information is shown out like the SQL Query.. No information at all..!
All because after i added the extra line which works fine in query.

The same thing happen when i tried adding the SQL into the main report's query..

I have no idea what is wrong with it. Does it have something to do with the main report ? Because my colleague tried using the subreport as main and she said it works.. She suggest it has something to do with the main report..

FYI: I never change codes in the VB application because the retriving of information is based on the SQL of the Crystal Report.

Help ?Would you mind including the SQL from the working version and the SQL from the non working ?|||Would you mind including the SQL from the working version and the SQL from the non working ?

SELECT
PROPLNHDR."APPL_NO", PROPLNHDR."INMODE", PROPLNHDR."TOTBPRM",
PRODOC."DOC_CODE", PRODOC."LETTER_DATE", PRODOC."RECD_DATE",
PROMED."MED_CODE", PROMED."LETTER_DATE", PROMED."RECD_DATE",
FC_S."FC_NAME", FC_S."RC_CODE",
LKBRANCHCODE."DESCRIPTION1",
LKAGTYPE."CHANNEL",
LKDOC."DOCGROUP"
FROM
{ oj (((("DLFSP"."dbo"."PROPLNHDR" PROPLNHDR inner JOIN "DLFSP"."dbo"."FC_S" FC_S ON PROPLNHDR."FC" = FC_S."FC") left JOIN ("DLFSP"."dbo"."PRODOC" PRODOC inner join "DLFSP"."dbo"."LKDOC" LKDOC ON PRODOC."DOC_CODE" = LKDOC."DOC_CODE") ON PROPLNHDR."APPL_NO" = PRODOC."APPL_NO") left JOIN "DLFSP"."dbo"."PROMED" PROMED ON PROPLNHDR."APPL_NO" = PROMED."APPL_NO") left JOIN "DLFSP"."dbo"."LKBRANCHCODE" LKBRANCHCODE ON FC_S."BR_CODE" = LKBRANCHCODE."BRCODE" AND FC_S."RC_CODE" = LKBRANCHCODE."RC_CODE") inner JOIN "DLFSP"."dbo"."LKAGTYPE" LKAGTYPE ON FC_S."AG_TYPE" = LKAGTYPE."AGTYPE"}
WHERE
LKAGTYPE."CHANNEL" = 'BANC'
ORDER BY
LKBRANCHCODE."DESCRIPTION1" ASC,
PROPLNHDR."APPL_NO" ASC

*** the above is the original code.. but the only thing i added to this line of SQL is to the WHERE clause
--> (PROPLNHDR."ST" IN ('PD', 'CO', 'AP')) AND

** it works in the SQL Query but not at the crystal report.. as in the main report.. This query is placed at the subreport..